multiple records shown in query

[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.

 

[Gerald Stanley]

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