Input Boxes That Don't Retain A Value

[legendv]

Assistance Needed:

I have a query that has 3 fields.
Date - Standard Date
Nosocomial - Checkbox
Number - Integer

The Date Field's Expression is a Between/And
The Nosocomial Expression is =True
The Number Expression is where I have the issue.

It's not actually a field. I need the arbitruary number only when the query is ran. All I need is for the query to ask it... I'm guessing an input box. I looked through the board and to no avail was unfound. I looked through the query builder and found the function Input (Something, Title, Something, xpos, ypos). I'm assuming that would be it, but don't know how to write it. Any suggestions?

 

[Newman]

Not sure I understood the question.
If you're looking for a popup box to appear, in which the user enters the number, here it is:
You give your field any name you want and in the Condition, you put this: [What is the number you're looking for?] (Or any sentence you like).
Since the query doesn't know the value for that field, it will ask the user.
Hope I understood correctly!
(got to practice more that english)
Au revoir!
Newman

 

[legendv]

Tried it Newman, didn't work - It asked me twice, so I left out the statement in the Condition/Criteria section and left it as just a field name and changed it's properties to a standard number and it worked. Thank You