parameter queries

[Guest]

When a parameter is used in the criteria of a query, where is the info typed in by the user stored. I need to access this info to use as a determinate for another field. I need to determine who reached 18 in a fiscal year. The fiscal year is the parameter and the information from that parameter will be used to determine who reached 18 during said fiscal year.

 

[Duane Hookom]

You can reference the parameter like you would a field/column in the query
ie: [Enter Fiscal Year]

--
Duane Hookom
MS Access MVP

When a parameter is used in the criteria of a query, where is the info

typed in by the user stored. I need to access this info to use as a
determinate for another field. I need to determine who reached 18 in a
fiscal year. The fiscal year is the parameter and the information from that
parameter will be used to determine who reached 18 during said fiscal year.

 

[John Vinson]

When a parameter is used in the criteria of a query, where is the info typed in by the user stored. I need to access this info to use as a determinate for another field. I need to determine who reached 18 in a fiscal year. The fiscal year is the parameter and the information from that parameter will be used to determine who reached 18 during said fiscal year.

It isn't stored anywhere, but you can reuse the parameter as many
times as needed within the query. Just spell it exactly the same way
in each instance.

 

[John Vinson]

When I use <=([Begin Date])-6574 an error message is produced that tells me the query is too complex. If I use an actual date - 6574 it flies just fine. Thank you for the solution thus far.

Try

<= DateAdd("d", -6574, CDate([BeginDate]))