Show all records with parameter prompt

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PHisaw - 19 Nov 2007 19:46 GMT

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]

Reply to this Message

Jerry Whittle - 19 Nov 2007 20:15 GMT

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

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

Signature

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

> Hi,
>
[quoted text clipped - 16 lines]
> Between [Forms]![fStatusCount]![StartDate] And
> [Forms]![fStatusCount]![EndDate]

Reply to this Message

PHisaw - 20 Nov 2007 15:51 GMT

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:
>
[quoted text clipped - 21 lines]
> > Between [Forms]![fStatusCount]![StartDate] And
> > [Forms]![fStatusCount]![EndDate]

Reply to this Message