I need to check a table to see if the record is there using two columns

[Harold7]

I need to check the below table to see if the record is there using VBA when I click the button. Then run an append query if the record doesn't exist, and run an update query if the record there. Please note that I should only add a new record if both the EmployeeID and AttendanceDate do not exist.

The code that I have tried so far is this:

If DLookup("EmployeeID", "AttendanceTable", "EmployeeID= '" & txtEmployeeID & "'") > 0 Then

' Run update query

Else

' Run append query

End If

AttendanceTable

AttendanceID	AttendanceDate	EmployeeID	EmployeeName	AttendanceCode
000001	08/08/2023	101	Adam	P
000002	08/08/2023	102	Sam	P
000003	08/08/2023	103	John	P

[pbaldy]

At the bottom is an example of multiple criteria:

http://theaccessweb.com/general/gen0018.htm

[June7]

Cross post https://stackoverflow.com/questions/...pend-using-dlo

[Micron]

@June7 - are you sure that's the right link? The first post seems to indicate the thread is 12 years old.

[Harold7]

At the bottom is an example of multiple criteria:

http://theaccessweb.com/general/gen0018.htm

Thank you, that was very helpful.

[pbaldy]

Happy to help!

[June7]

Link opens correct for me. Question asked 23 hours ago.

[Welshgasman]

@June7 - are you sure that's the right link? The first post seems to indicate the thread is 12 years old.

Works for me, but shouldn't DCount() be used if comparing to > 0 ?

[June7]

Works for me, but shouldn't DCount() be used if comparing to > 0 ?

That was noted in comment below StackOverflow question.

[Micron]

Then there must be something wrong with what the site shows or "Asked 12 years, 2 months ago" doesn't mean what I think it does.

[June7]

Micron, don't know why you are opening that question. That is the question that was flagged as an old question with answer relevant to new question. The link I posted is to the new question.

[pbaldy]

FYI if I click on your crosspost link I also go to the 12-year-old question that Micron gets.

[Micron]

Micron, don't know why you are opening that question

Because that's where your link takes me. Never mind, not real important.

[Welshgasman]

Hmm, on my phone with chrome it takes me to the 13 year old thread? On my laptop it is fine?

[pbaldy]

I wonder if people who are registered and logged in at SO get a different result? I'm not a user there.