Parameters Function

  • Thread starter Thread starter Lindsay
  • Start date Start date
L

Lindsay

I have created a parameters query for a purchase order report so a user
can easily find one specific purchase order by number. The parameter
asks for a range though. Is there any way that I can make the system
search for just one PO number instead of a range?
 
Lindsay said:
I have created a parameters query for a purchase order report so a user
can easily find one specific purchase order by number. The parameter
asks for a range though. Is there any way that I can make the system
search for just one PO number instead of a range?
Click to expand...


Lots of ways. What is your current criteria and how is it
applied to the query?
 
I put Between [enter the beginning date] And [enter the ending date] in
the criteria of the PO number field in teh report query.
 
Lindsay said:
I put Between [enter the beginning date] And [enter the ending date] in
the criteria of the PO number field in teh report query.
Click to expand...


What? You are prompting for a date range in the PO number
field??? Somehow, I am having trouble understanding what
you have and what you want.

If you want to be prompted for a single PO number then use a
criteria like:
= [Enter Po Number]
 
Sorry. I didn't realize what I typed. I do have a date range in
another report's query. I meant to type Between [enter the beginning
PO number] And [Enter the ending PO number]. I will try =[Enter PO
number]

Thanks,
Lindsay
 
Back
Top