two parameter boxes

[janed]

i have a report that is linked to a query which runs by using two parameter boxes. one of the boxes asks for a room number and the other for a port number. however, unless i type in both the room number and the port number i get back a blank report. it will sometimes be the case that we will only know one or the other and i need the report to be able to find a record based on one or the other and not just on both. any ideas?

 

[Graham T]

Janed

Have you got the query set up as an AND query: Is it asking for [Enter Room Number] AND [Enter Port Number].

If this is the case you will need to enter both values to return a result.

It maybe better to set this up as an OR query
[Enter Room Number] OR [Enter Port Number]

HTH

 

[janed]

thanks a million. ok. i think i do have it set up as an and query. however if these are two different fields how do i know which field to put the criteria into?

 

[Graham T]

In your query design grid type [Enter Room Number] in the first criteria row underneath your RoomNumber column.

Enter [Enter Port Number] in the second criteria grid row underneath your PortNumber column.

HTH