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
"Novice2000" <Novice2000[ at ]discussions.microsoft.com> wrote in message
news:34D57E92-D440-4492-B2AC-91EE09E15AEA[ at ]microsoft.com...
[Quoted Text] > 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" wrote:
>
>> SELECT * FROM YourTable WHERE CustomerID = 10222;
>>
>> Regards
>>
>> Jeff Boyce
>> Microsoft Office/Access MVP
>>
>> "Novice2000" <Novice2000[ at ]discussions.microsoft.com> wrote in message
>> news:B1503A7F-54D4-4842-9D37-C5C8EEB0272B[ at ]microsoft.com...
>> > 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?
>> >
>>
>>
>>
|