HELP-Passing an Access query to Crystal

[Dross]

I built an Access query and need to pass it to Crystal but I'm not sure how. I need help ! I guess I need to pass paramID, but how? If you can help THANKS !! Here is the query:

SELECT Invoice.ClientSSN, Invoice.LastName, Invoice.FirstName, Invoice.Address, Invoice.Address2, Invoice.City, Invoice.StateProvince, Invoice.ZipCode, Client.HomePhoneNumber, Invoice.InvoiceNumber, Invoice.TaxWiseInvoiceNum, Invoice.OfficeID, Invoice.InvoiceDateTime, Lookup_ProductType.Description, Invoice.TaxYear
FROM ((Invoice LEFT JOIN Client ON Invoice.ID = Client.ID) LEFT JOIN Office ON Invoice.OfficeID = Office.OfficeCode) LEFT JOIN Lookup_ProductType ON Invoice.ID = Lookup_ProductType.ID
WHERE Invoice.ID = [paramID];

 

[Guest_imported]

Sure you got that right? Looks like Access is supposed to receive the parameter , not supply it.

Mike

 

[Dross]

Your guess is as good as mine, I am learning as I go.

 

[080898pll]

Link Crystal reports to the query not the mdb file and create the report as normal. The query will refresh each time the report is run.