Variable from Parameter Query

[OldCityCat]

Is there a way to assign the data from and Input box of a parameter query to
a variable?

Here's the parameter for the query;
((DatePart('ww',[dbo_Hse.ExpDate],2,2))=[Enter Week Number]))
I would like to assign the "Week Number" the user enters to a variable.

Thanks for any and all suggestions

OCC

[ajetrumpet]

not sure, but you might want to try running the query from a form and instead of using an input box, use a control as criteria instead. throwing data from a control to a variable memory is simple one liner code

[KathyL]

I’m thinking it would be good to have the [Enter Week Numbers] as a separate column in the query, and give it an expression name, like UserWeekNumber: [Enter Week Number]
Then I think you might be able to access that column as a calculated field and put it on a form, even invisibly.
And your original calculation could also refer to the expression name.

[OldCityCat]

Sorry If I didn't explain myself very well,I try again'
My query works as expected It prompts me for the week number and returns the data I need.

What I need is to assign that week number that was just used in the query to a variable.

I need to use the same week number to check for records in a table before I appended new records.

I hope this makes sense.

Thanks
Gil

[weekend00]

you can not assign the data from and Input box of a parameter query to
a variable. but you can pass the data from a variable to a query.

Why don't try it on the other way, save the date to a variable (input through textbox or messagebox), then run you query with this variable, the use the same variable to check for records in the other table before you append new records.