multiple records shown in query

  • Thread starter Thread starter kesk
  • Start date Start date
K

kesk

Hi,

I am desinging an expense report database where in I have 3 tables,
Statement, Exp, Bookings. I use statement as the main table and link it to
the other two tables. I have designed a form-subform type of form where i
enter the relevent data in 1 form.

To make a report, i have created a query. When the Bookings table has more
than 1 entry for a related id from the statement table, the result of the
query is doubled : a small scenerio : Statement has 1 record, exp has 3
records and bookings has 2 records. When i run the query there are 6 rows
displayed where as i want only 3 records from the Exp table. When the
bookings has 3 records, then the query displays 9 rows of data (3 X 3).

I have tried the 'Unique records' in the properties, still no luck. Can
someone tell me how can i achieve this.

thanks

kesk


If permitted, i can send my database also, its very small.
 
This is to be expected where there is no relationship
between the two tables Exp and Bookings If you wish to
have all the bookings then all the expenses for a statement
on separate rows you should use a Union query.

Hope This Helps
Gerald Stanley MCSD
 
Back
Top