Recent content by AAshley

Thanks! I went back in and made a few changes to the query and I was able to get it to populate everything as I wanted it. Thanks a mil!

This is a brand new database. The data you see has been created to force entries and verify if it's generating the information necessary. What you see is what I have. The ID number is an AutoNumber generated by the name of the person. There are 2 people in the entire database at this time. There...

Here is a spreadsheet with the edited data. Essentially I just need their first, or any, sign-in recorded between the start and end date.

The first data set are the SignInDate and Time fields, coming from a table names "Tbl_SignIn". The second data set are the ID Numbers and Names, with all of the other data fields attached, coming from a table called "Tbl_Main". They share a common field, ID, which links the two tables...

No change using this method either. Still counts all of the entries. I think it's not considering the records duplicates because each name has a unique date and time attached to them.

My apologies...

Okay sure. So the table (Tbl_SignIn) has the following fields: SignInDate, SignInTime, ID The query (Qry_SignIn) then includes those above and a few more, making the complete list of fields: SignInDate, SignInTime, ID, Start Date, End Date, Gender, Race, Lang1, Lang2, Age What I'd like is to...

I've tried that but it continues to give a full count of all sign-in's. :banghead:

Hi everyone, I used to be a member of this forum a few years ago and haven't had to create any databases in quite some time. I can't remember my old login so I created a new one. In any event I'm hoping I can get some help with a problem I'm having with a new database I'm working on. I have a...