O
Opal
I am creating an inventory database. Inventory is taken 3 times per
day based on shift start. I want to be able to create a parameter
query and then a report that will show the inventory taken at the
start of each shift. There are nine areas that are inventoried each
shift. I need to be able to query by date and time. I want the times
to be broken down by shift name (i.e. Days, Afternoons, Nights). The
form that feeds the table where the query is run has a txtDate field
and txtTime field with default values of =Now() so that when the data
is saved to the Inventory table the time and date are there
automatically. However, with nine areas to inventory and several
people entering the inventory into the database, it will not be
entered at exactly the same time each shift but the date is the same.
Time is formatted to "medium time" and inventory will be taken
between:
Days = 6:00am to 7:00am
Afternoons = 2:00pm to 5:45pm (due to two different afternoon shift
start times)
Nights = 10:00pm to 11:00pm
Since there are three separate inventories taken I can't see how to
use "Where....between" as the criteria in a parameter query. But how
would I tackle this in VBA?
day based on shift start. I want to be able to create a parameter
query and then a report that will show the inventory taken at the
start of each shift. There are nine areas that are inventoried each
shift. I need to be able to query by date and time. I want the times
to be broken down by shift name (i.e. Days, Afternoons, Nights). The
form that feeds the table where the query is run has a txtDate field
and txtTime field with default values of =Now() so that when the data
is saved to the Inventory table the time and date are there
automatically. However, with nine areas to inventory and several
people entering the inventory into the database, it will not be
entered at exactly the same time each shift but the date is the same.
Time is formatted to "medium time" and inventory will be taken
between:
Days = 6:00am to 7:00am
Afternoons = 2:00pm to 5:45pm (due to two different afternoon shift
start times)
Nights = 10:00pm to 11:00pm
Since there are three separate inventories taken I can't see how to
use "Where....between" as the criteria in a parameter query. But how
would I tackle this in VBA?