Time Rec Multi Entries x day - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Time Rec Multi Entries x day

Johnny Alvarez

3 years ago

I created two tables that track check in and check out times with a query to show the entries. The problem is on the query, if I enter a second entry for the day on the results I get a third record for the entry as it pairs all entries.

Let say I create the following entries:
1st entry is 10 AM to 1005 AM
2nd entry 1010 AM to 1015 AM

On the query I will see a third record as 1000 AM to 1015
The more entries for the day the more pairing to 1000 AM I will see on the query.
is this something ALZ has covered before in any of the training videos or templates?

	Johnny Alvarez OP @Reply 3 years ago

	Johnny Alvarez OP @Reply 3 years ago
In the picture... The second record would be the incorrect one vs the third being the true entry. Thanks for any help!

	Sami Shamma @Reply 3 years ago
Share your two tables and the Query. your description is vague.

	Kevin Robertson @Reply 3 years ago
Not really sure why you need 2 tables. Check out this video: Manage Rental Inventory In the Extended Cut Richard builds a Check-In/Check-Out System.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View