Help with Multiple record - one client

[Guest]

Hi,

We receive an excel workbook of information from an outside source. Within
this table the customer may have several record lines assigned to their
customer number. Each line has the customer number, a purchase date, a part
number, description and cost.

Example:
10222 07/10/2006 carbide burr 3/8 inch $234.00
10222 08/17/2006 widget 1 inch $456.00
10222 09/22/2006 o-ring 1/2 inch $123.00

I need to be able to pull back all of this data into a report and display
the data for each record on one page. How can I design a query to pull back
multiple records?

 

[Jeff Boyce]

SELECT * FROM YourTable WHERE CustomerID = 10222;

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks Jeff

Yes, that is good, but that only brings back that one client. Is there a
generic customer ID that can be substituted for 10222 that will bring back
all clients with their individual data in the report format?.

 

[Jeff Boyce]

Queries are not reports. Queries provide the raw data for reports.

If you don't want to limit it to the one CustomerID, don't include a WHERE
clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP