Query by User

[JoMonto]

Hello-

I have a parameter query that I need to add one more feature to - and
I'm stuck.
The parameter-query portion is pretty simple, it's based on a
"ScreeningDate" field -
"Between [Enter Start Date] And [Enter End Date]"

Works fine... but here is what else I would like to do.

The table now has three "ScreeningDate" fields. Date1, Date2, and
Date3.

I would like the user to be able to select which date field (Date1,
Date2, Date3) the parameter query will be based on.

Any ideas?

Thank you for your help.

john-

[Rog]

John,

The problem is that your database is not normalized. You should not
have three screening date fields. I suppose this is a database of movie
screenings? If so, you should have --a the very least-- two tables:
one for the movies and one for the screening dates. The fields in the
screening dates table should be the movie ID and the date screened.
That way you can have several screening records for each movie record.
You then link the two tables in your query so that only one set of
"between... and" parameters is required.

Rog

[JoMonto]

Thank you for you reponse... and I understand this - but I'm still
going to make a feeble attempt at justifying myself <smile>

This field is actually for dental screenings. So.. on the first
screening date, this procedure was performed. The next time the child
was screened (the 2nd screening date) this was found , the procedure
was... and so forth for the 3rd date. I have specific treaments tired
to the screening dates.

Everything works fine. But in this instance, we have to do some general
counts.... quarterly information. So as it stands.. I have to change
the parameter query by hand - for the 2nd and 3rd dates.

I would love to dump this off to the users to run... but with this 3
date things, I have to run it for them.

Does this make sense or change the situation?

Thanks again for your response,

john

[Terry Kreft]

So provide three queries each query having the parameter on the appropriate
field., and present those as options to the user.

They choose the screening date they want and enter the Start and End dates,
depending on the option they choose use the appropriate query.

--
Terry Kreft

"JoMonto" <jo*****@zeus.kern.org> wrote in message
news:11*********************@g44g2000cwa.googlegro ups.com...

Hello-

I have a parameter query that I need to add one more feature to - and
I'm stuck.
The parameter-query portion is pretty simple, it's based on a
"ScreeningDate" field -
"Between [Enter Start Date] And [Enter End Date]"

Works fine... but here is what else I would like to do.

The table now has three "ScreeningDate" fields. Date1, Date2, and
Date3.

I would like the user to be able to select which date field (Date1,
Date2, Date3) the parameter query will be based on.

Any ideas?

Thank you for your help.

john-