Report Queries

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

Guest

Is it possible to use the same report for more than one query? If so, would
someone tell me how to do it. I want to use the same fields in a report but
be able to search for a specific record.

My current query searches for vehicles for a certain location when I select
the location from a combo box in my reports menu. I've got a command button
that you can also click and enter a specific inventory # for a vehicle and
pull it up. Currently, I do this by using two separate reports that look the
same.
 
Sounds like you could do it in one QUERY. Just modify your query to limit
by location if one is entered and to limit by stock number if one is
entered. In other words, leaving one blank would cause it to be ignored.


Like Forms![MyFormName]![InventoryNumber] and "*"

AND

Like Forms![MyFormName]![Location] and "*"
 
Thanks! For some reason I didn't think of that.

Rick B said:
Sounds like you could do it in one QUERY. Just modify your query to limit
by location if one is entered and to limit by stock number if one is
entered. In other words, leaving one blank would cause it to be ignored.


Like Forms![MyFormName]![InventoryNumber] and "*"

AND

Like Forms![MyFormName]![Location] and "*"



--
Rick B



Todd said:
Is it possible to use the same report for more than one query? If so, would
someone tell me how to do it. I want to use the same fields in a report but
be able to search for a specific record.

My current query searches for vehicles for a certain location when I select
the location from a combo box in my reports menu. I've got a command button
that you can also click and enter a specific inventory # for a vehicle and
pull it up. Currently, I do this by using two separate reports that look the
same.
Click to expand...
Click to expand...
 
Rick, where do I need to put the expressions? Should I put the
inventorynumber portion under that field and the same for the location field?

Rick B said:
Sounds like you could do it in one QUERY. Just modify your query to limit
by location if one is entered and to limit by stock number if one is
entered. In other words, leaving one blank would cause it to be ignored.


Like Forms![MyFormName]![InventoryNumber] and "*"

AND

Like Forms![MyFormName]![Location] and "*"



--
Rick B



Todd said:
Is it possible to use the same report for more than one query? If so, would
someone tell me how to do it. I want to use the same fields in a report but
be able to search for a specific record.

My current query searches for vehicles for a certain location when I select
the location from a combo box in my reports menu. I've got a command button
that you can also click and enter a specific inventory # for a vehicle and
pull it up. Currently, I do this by using two separate reports that look the
same.
Click to expand...
Click to expand...
 
Back
Top