Setting a Parameter for multiple fields

[erica573583]

I'm trying to extract data from multiple fields in a query by just asking the
user to input one set of parameter details.

I've set up a database that holds information on staff reviews and part of
that is to allow the Manager's to print off a report (linked to a query) that
will show when reviews are due by month. I want the Managers to input the
date from and to they would like to view and then have the query analyse the
data in the 15 Review Date fields, extract the dates that match and show
these in a report. Can anyone help as to what I need to do?

 

[Duane Hookom]

It sounds like you have 15 similar date fields. IMHO, this is not a good
design. I would attempt to normalize the tables by creating a table where
each review date creates a new record in a related table.

If you can't change your structure (or if I am mistaken regarding your
structure), I would create a union query that normalizes your table. It would
help to know the significant table and field names.

 

[erica573583]

Yes there are 15 date similar dates fields, each calculate and schedule a 10
weekly review date in the next field so that the user does not have to work
out and input each individual date. If there's something better I could do
so that I can continue with setting up a Review Schedule Report please let me
know - I appreciate your honesty!!

 

[Duane Hookom]

I would expect there would be data in a table somewhere that stores the time
interval between reviews. Use this information with your base review date to
create/add records to a reviews table that has one record per individual per
review.

Without understanding your significant tables and fields, I can't be of much
detailed assistance.