Show all records with parameter prompt

[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]

 

[Guest]

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

PumpType
Like "*" & [Forms]![fStatusCount]![Vendor]

 

[Guest]

Thanks, Jerry, for the prompt reply and solution. That did the trick!!

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.

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]