Microsoft Access Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a database that I have created the tables are linked Excel spreadsheets.
When I run a query (for total number of receipts/rejects) and there is no
corresponding information in the table, how do I get the organization's
number, name, and number of items to display (instead of a blank response)? I
would like to have a values like: Company Number = "1234"; Company Number =
"ABC Industries"; QTY Received = "0"; and QTY Rejected = "0".

Also, in another query, I have the same issue except I want the lines
ordered/received counted, but if there are no lines to count a blank response
is returned. I would like to have a values like: Company Number = "1234";
Company Number = "ABC Industries"; Lines Ordered = "0"; and Lines Received =
"0".

Any ideas would be greatly appreciated. Thanks!!!
 
A couple ideas...

First, you may want to look into Crosstab Queries as one way to do this.

Next, you may need to used directional joins (all from "table1" and any from
"table2") and the Nz() function.

Finally, consider that queries get data, but aren't great at displaying it.
Use a report if you need more control over the display, and base the report
on your query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top