N
Novice2000
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?
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?