T
Todd
I asked this question the other week and got a response but apparently I was
doing something wrong.
My question is that I've got a query which is the record source for a
report. The report is designed to show expenses for vehicles in my car pool.
I've got the first criteria set for a specific date range (which is entered
from two text boxes in my reports menu), which works fine. My second
criteria sorts for vehicles in a specific location (which you would select
from a combo box in my reports menu). The criteria for this in the query is
[Forms]![frmrptparam]![locationtblsort] and I've also got an expression in
the query with the same info except that in the OR field I have "Is Null"
where if you don't select a location it will show all locations. Both of
these criterias work fine.
What I'd like to do now is add another text box in the reports menu to give
the user the option also to sort by vehicle inventory number. I did the same
thing for this criteria (inventory number) as I did for the second criteria
(Location) above. The problem I'm having is that I can't just select an
inventory number from my combo box and pull that information. I have to
select the location and then the inventory number before the report will show
the information on the vehicle inventory number selected.
Is there a way to fix this to where I can either select the location or
inventory number and pull the information without having to create another
report specifically for the inventory number sort?
Any assistance would be appreciated.
doing something wrong.
My question is that I've got a query which is the record source for a
report. The report is designed to show expenses for vehicles in my car pool.
I've got the first criteria set for a specific date range (which is entered
from two text boxes in my reports menu), which works fine. My second
criteria sorts for vehicles in a specific location (which you would select
from a combo box in my reports menu). The criteria for this in the query is
[Forms]![frmrptparam]![locationtblsort] and I've also got an expression in
the query with the same info except that in the OR field I have "Is Null"
where if you don't select a location it will show all locations. Both of
these criterias work fine.
What I'd like to do now is add another text box in the reports menu to give
the user the option also to sort by vehicle inventory number. I did the same
thing for this criteria (inventory number) as I did for the second criteria
(Location) above. The problem I'm having is that I can't just select an
inventory number from my combo box and pull that information. I have to
select the location and then the inventory number before the report will show
the information on the vehicle inventory number selected.
Is there a way to fix this to where I can either select the location or
inventory number and pull the information without having to create another
report specifically for the inventory number sort?
Any assistance would be appreciated.