Parameter Query Problem

A

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.
 
K

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.
 
A

aponnezhan

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top