Query/Report Help (1 Viewer)

[JoshuaNerenberg]

I am designing a database for my company's vendor/customer claims. Part of the database is the quarterly claims reports we normally do. I am stuck on one report, using a query to get the information I need.

The report we have is a list of all the customers we shipped in that time frame with the amount rejected, amount shipped, and the rejection %.

The amount shipped is a number that will be inputed by the user.

The amount rejected is what I am having trouble with. In another query, I am summing the amount rejected for each customer. I want to use this number ,but I also want to show all the customers, even those with no weight rejected.

Right now, all the query will output is the customers who have claims.

Does anyone know how to accomplish this task?

 

[anna the third]

Hi,

You will have to use a right or left join for this.
It is possible to do this using the query design interface in Access. Just select the link between to table. Click your right mouse button and select "Join properties". You get a selection screen that, I think speaks for itself.

anna