View Full Version : Query Question for Parameter Values!


stu_c
11-24-2009, 05:40 AM
Hi all
I have got a parameter value that searches reference numbers for example C12345

A parameter pops up and asks for the Ref number and you type as needed and brings records up.

is there any possible way you can get a parameter value to Automatically put the C in place so all we have to do is type the number in the parameter field e.g. 12345?

ajetrumpet
11-24-2009, 05:56 AM
WHERE

[ref field] = "C" & [parameter]