On 6 Feb 2006 03:59:13 -0800, "Decreenisi" <cy*********@hotmail.com>
wrote:
Typically the lookup tables become new tables. E.g. tblRejects has
fields ReasonID and ReportedByID. These are linked to tblReasons
(ReasonID, Reason) and tblEmployees (EmployeeID, FirstName, LastName)
etc. In a form where you enter rejects, you offer multi-column
dropdown lists where the user thinks he selects a Reason, but he's
really selecting the hidden ReasonID which is stored in the
tblRejects.ReasonID field.
Pivot tables are called Crosstab queries in Access. There is a wizard
entry when creating a new query, or you can study the Transform
statement.
-Tom.
Hi,
I have to convert an existing spreadsheet for rejects into an access
database. My problem is I use a load of lookup tabels in excel. How do
I approch this in access. Also, just a general question, can you do
pivot tables in access.
Thanks