How to store field value in variable?

[kellstee]

Sorry, I know this is the most basic question and I've spent hours searching. I must just be using the wrong search criteria or the explanations are over my head.

I have a value in a one-row table that I divide by the number of days in the current month. I need this value often for other query calculations. Am I able to just store this calculated value in a variable and then call it in my queries when I need it?

If so, how do I do this?

Thanks in advance!
Kelly

 

[Remou]

It may be best to use DLookUp.

 

[PHV]

In JetSQL there is no variables but parameters.
Store you calculated value in a textbox and reference it in your queries:
[Forms]![name of mainform]![name of textbox]

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[kellstee]

Thanks for the replies. When I put the value in a form, the query only seems to recognize the form field when the form is open. Is this expected behavior?

Thanks again!

 

[Remou]

Yes, it is.

You can use DlookUp to get a value from a table, whether it is open or not.