Unanswered: displaying summary from tables into form
I am new to Access and I am having problems displaying summary data from various tables within a form.
I have a main table with the primary key BCNO and I have two smaller tables, LOCAL and DISTANT both of which have 3 fields, BCNO, DATE and LOCATION and there can be multiple entries for the same BCNO in each table.
I would like to display in a form for each BCNO in the main table the first DATE and corresponding LOCATION from both LOCAL and DISTANT tables and to identify which occured first LOCAL or DISTANT.
I have generated two queries to produce the first local and distant occurances but the message #name appears if I used the information from the queries within the form I am designing.
Thanks for the information. I had thought of combining the two tables into one which may give me more flexibilty but at the moment I am trying to convert our databases held in an old SMART system where the two tables are held separately.