Problem with query (Access 1001)

Topic

New Reply

I have two tables, client and services. I appended records today to the services table from April to May. The two tables are tied together with an appropriate primary/foreign key, which has proven to work in other situations. Next a query was developed with just the service table all April to November service records show appropriately. Next the client table was added to the QBE at this point the April to May records no longer show. This is without adding a field from the client table.

Does anyone have any ideas of what the problem is? Thank you for your help.

Have a happy turkey day. Keep your family close. Fay

Reply | Quote

Replies

Is the client key updated as well?

Dan

Reply | Quote

That is a possibility. I guess that will need to be checked next week. Thanks

Have a good holiday.

Fay

Reply | Quote

Did you use an inner join between the two tables (all records that exist in both tables) ? If so, you need to check those new service records to make sure that a matching client record exists for each of them.

Reply | Quote