Questions tagged [ms-access-2010]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
881 views

How to subtract records from a table based on their existence in another

I have an Access 2010 table Assignment key Empl Number key Year Number key Week Number key Proj Number It assigns employees to zero or more projects for given work weeks, thus, all four ...
0
votes
1answer
272 views

How to save the design of an Access database — not the content — as text?

How can I save the entire design or specifications of an Access 2007 database -- not the data content -- as text? I have fallen foul of the "Enter Parameter Value" bug whereby a query pop-up shows an ...
0
votes
1answer
216 views

Convert an interaction matrix into a ternary relation

I have what I'm calling a sparse "interaction matrix" of data in MS Excel that I wish to convert into a "ternary relation" (table) in Access. The spreadsheet data are in this pattern: Name Act-1 ...
0
votes
1answer
2k views

JOIN on Microsoft Access derived table not working

Can you please help me why my below SQL is not working in Access 2010? SELECT Table2.Product, Table2.Color, SEQMAX, Table1.Attribute FROM ( Table2 LEFT JOIN ( SELECT ...