Confused!?!

[Roger]

I have linked 4 tables. Customer: Stocks: Invoice Hdr:
Invoice Dtl.

Through 3 queries one with customer name and unique stock
code nr, the second with stock details and the third with
sales details for the stock (in stock details), I am
making a fourth query.

Then I try to add, calculated fields which then filters
sales details for stock per month; eg sales for jan 2003,
feb 2003 etc......

I run this query and the unique stock code nr changes in
the first table, I think this happens when there are no
sales records for the product in the month. When testing
the query. (None of the queries actually modify any data)

If anyone can understand what i have typed please help

Thanks

Roger

 

[John Vinson]

Through 3 queries one with customer name and unique stock
code nr, the second with stock details and the third with
sales details for the stock (in stock details), I am
making a fourth query.

Then I try to add, calculated fields which then filters
sales details for stock per month; eg sales for jan 2003,
feb 2003 etc......

I run this query and the unique stock code nr changes in
the first table, I think this happens when there are no
sales records for the product in the month. When testing
the query. (None of the queries actually modify any data)

Ok... you have three queries. You "run this query".

What are you running? How? Could you post the SQL view of the query
that you're running?