Hi,
I desperately need help on a time issue.
I have an Access query that exports data to an Excel spreadsheet (so far so good). Unfortunately, the data is exported incorrectly. Here is the problem…
I need the data to export for shifts “B” and “C” between particular times.
Example:
Shift B: Export data on 3/10/06 between 4:00 PM and 11:59 PM
Shift C: Export data on 3/11/06 between 12:00 AM and 8:30 AM
Currently, the data for “C” shift is exported for the incorrect date (3/10/06) and times.
I am not strong in SQL and would appreciate some assistance.
I desperately need help on a time issue.
I have an Access query that exports data to an Excel spreadsheet (so far so good). Unfortunately, the data is exported incorrectly. Here is the problem…
I need the data to export for shifts “B” and “C” between particular times.
Example:
Shift B: Export data on 3/10/06 between 4:00 PM and 11:59 PM
Shift C: Export data on 3/11/06 between 12:00 AM and 8:30 AM
Currently, the data for “C” shift is exported for the incorrect date (3/10/06) and times.
I am not strong in SQL and would appreciate some assistance.
