Help with queiries.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have made a database that logs testing procedures for different electrical
units. In a first table i have a serialno field. Then i have a few tables
which contain the results for the different tests. These tables all lookup
the serialno from the first table.

What i am looking to do, is to display all records for a certain serialno.
Is this possible.

Thanks in advance
 
Very possible. We can't see your tables, fields, data so it is a bit
difficult to be more specific. You could consider subreports or a union
query.
 
This is how my tables are set out.

Table: UnitData
Fields: Serialno, Type, datecreated

Table: CD23Test
Fields: Testno(autonumber), Serialno(lookup from[UnitData]), date,
screenbootup, AS607-35SN, CurrentConsumption...(about 10other test values)

Table: DA36Test
Fields: Testno(autono), Serialno(lookup from[UnitData]), date, Upload,
Canstatus, pageswitch, (about 15other test values)

There are more tables for tests of different units in a similar format.

Hope this is clear and help my question.

Cheers
 
It looks like your tables might be significantly different taht each test
table should be a subreport. Place these subreports on a main report that
has a record source of your Unit Data.
 
Back
Top