Skip query box

[stephendeloach via AccessMonster.com]

When i run a report sometime i want it to display certain "Equipment" and
sometime i want it to display all. What can i type in the paremeter box that
allows everything in the "Equipment" field to display? Thanks

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200704/1

[Tom van Stiphout]

Re: Skip query box

On Wed, 04 Apr 2007 20:04:30 GMT, "stephendel oach via
AccessMonster.c om" <u32891@uwewrot e:

Use the LIKE keyword rather than =:
select * from Equipments
where EquipmentName LIKE [Give Equipment:]

Then if you enter * you will get all.

-Tom.

>When i run a report sometime i want it to display certain "Equipment" and
>sometime i want it to display all. What can i type in the paremeter box that
>allows everything in the "Equipment" field to display? Thanks

[stephendeloach via AccessMonster.com]

Re: Skip query box

That didnt seem to work? Dont know if I am doing it right... This my query in
SQL..

SELECT RHC.Rig, RHC.Equipment, RHC.Hours, RHC.[Cost Per Hr]
FROM DIW INNER JOIN RHC ON DIW.[Invoice #] = RHC.[Invoice #]
WHERE (((RHC.Rig)=[forms]![ParamForms]![Rig]) AND ((RHC.Equipment )=[forms]!
[ParamForms]![Equipment]));

Now I need to insert what, where?

Thanks

Tom van Stiphout wrote:

>Use the LIKE keyword rather than =:
>select * from Equipments
where EquipmentName LIKE [Give Equipment:]
>
>Then if you enter * you will get all.
>
>-Tom.
>

>>When i run a report sometime i want it to display certain "Equipment" and
>>sometime i want it to display all. What can i type in the paremeter box that
>>allows everything in the "Equipment" field to display? Thanks

--
Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200704/1