Hi, guys! New to this forum.
Ok I hope I can explain this simply enough.
I have a Form that generates a simple Weekly Report. On this form I have two Text Boxes with a [txtDateFrom] and [txtDateTo]. My week starts Thursday
at 2pm and ends the next Thursday at 2pm (7 days).
My query attached to this Form has the Between Dates in the criteria and this works perfectly except I want to be able to get all records after 2pm on
Thursday and before 2pm the next Thursday. However when I originally entered the data into the table I didn't set the date to time as well and instead made a column of After 2pm and in that column anything done After 2pm on Thursday has "After 2pm". Clearly now I know I should not have done this, but be that as it is, is there anyway to program getting the report to only grab the records from Thursday After 2pm to Thursday Before 2pm?
Here is an example of my Query Data Sheet:
Date of Transaction | Type | Amount | After 2pm | Branch |
7/4/2019 CHECK $150.00 TLOC
7/4/2019 CHECK $150.00 TLOC
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CHECK $150.00 TLOC
7/5/2019 CHECK $150.00 TLOC
7/6/2019 CHECK $150.00 TLOC
7/7/2019 CHECK $150.00 TLOC
7/8/2019 CHECK $150.00 TLOC
7/9/2019 CHECK $150.00 TLOC
7/10/2019 CHECK $150.00 TLOC
7/11/2019 CHECK $150.00 TLOC
7/11/2019 CHECK $150.00 After 2pm TLOC
When I run the query I only want the above to show the ALL records from Thursday After 2pm to Thursday before 2pm as shown here:
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CASH $230.00 After 2pm TBOD
7/4/2019 CHECK $150.00 TLOC
7/5/2019 CHECK $150.00 TLOC
7/6/2019 CHECK $150.00 TLOC
7/7/2019 CHECK $150.00 TLOC
7/8/2019 CHECK $150.00 TLOC
7/9/2019 CHECK $150.00 TLOC
7/10/2019 CHECK $150.00 TLOC
7/11/2019 CHECK $150.00 TLOC
Is that possible? Or do I then have to change my table completely.
Please help! Thanks!
Regards, Phil