Setting value

[John]

I have a user prompted input that I need to compare in two
statments on the same query, is it possible to assign the
user prompted value to a variable then check the variable
against two differerent functions

 

[Tray]

John

Try
myVariable = InputBox("Question to user", "Title of Inputbox"

This will assign the value of the inputbox to the variable 'myVariable'. You can then compare this as required

The InputBox function returns a string so you may need to do some conversions depending on what type of value you want (and the usual data validation)

Hope this helps
Tra


----- John wrote: ----

I have a user prompted input that I need to compare in two
statments on the same query, is it possible to assign the
user prompted value to a variable then check the variable
against two differerent function