Show all records with parameter prompt

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm not sure what I'm missing but I have a query set up with the following
fields and prompts underneath each. Everything worked great. Report opens
with information shown and calculated. Now, boss wants to see all jobs
regardless of vendor or model and I can't get the query to list every entry.
Can someone please tell me what I need to enter to show all records?

Thanks for any help,
Pam

PumpType
[Forms]![fStatusCount]![Vendor]

Model
Like "*" & [Forms]![fStatusCount]![Model] & "*"

Invoiced
Between [Forms]![fStatusCount]![StartDate] And
[Forms]![fStatusCount]![EndDate]
 
Your model should work if left blank. That leaves Venor. Below should do it:

PumpType
Like "*" & [Forms]![fStatusCount]![Vendor]
 
Thanks, Jerry, for the prompt reply and solution. That did the trick!!

Jerry Whittle said:
Your model should work if left blank. That leaves Venor. Below should do it:

PumpType
Like "*" & [Forms]![fStatusCount]![Vendor]
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

PHisaw said:
Hi,

I'm not sure what I'm missing but I have a query set up with the following
fields and prompts underneath each. Everything worked great. Report opens
with information shown and calculated. Now, boss wants to see all jobs
regardless of vendor or model and I can't get the query to list every entry.
Can someone please tell me what I need to enter to show all records?

Thanks for any help,
Pam

PumpType
[Forms]![fStatusCount]![Vendor]

Model
Like "*" & [Forms]![fStatusCount]![Model] & "*"

Invoiced
Between [Forms]![fStatusCount]![StartDate] And
[Forms]![fStatusCount]![EndDate]
Click to expand...
Click to expand...
 
Back
Top