Parameter Query Problem

[aponnezhan]

Hi, I'm creating a Paramater Query based on the date of a payment and receipt
number for a record which includes 1st payment, second payment, and 3rd
payment and 1st receipt number, 2nd receipt number, and 3rd receipt number
fields. How do I retrieve only the field results which match the parameter
criteria without pulling up other field values of that record which may not
fit the search criteria? Thank you for any suggestions.

 

[KARL DEWEY]

I suggest that you change you table structure to something like this ---
Payments ---
PayID - autonumber
Invoice - (could be SalesID - relates to sale & customer)
Payment - number - integer
Receipt - number - integer
PayDate - DateTime

The above table layout lets you pull record data as you might need it.

 

[aponnezhan]

Thanks for the input, with some restructuring I'll be more selective in my
queries and can make this work.