findfirst - 2 search criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i wish to find a record based on 2 criteria, in this case i wish to search
for a particular job id and then date type as each job id could have a
multiple amount of date types.

rs.Findfirst "[Job ID] = " & aJob AND "[Date Type] = " &aDate

i am not sure how to program the AND.
 
liz said:
i wish to find a record based on 2 criteria, in this case i wish to
search for a particular job id and then date type as each job id
could have a multiple amount of date types.

rs.Findfirst "[Job ID] = " & aJob AND "[Date Type] = " &aDate

i am not sure how to program the AND.
Click to expand...

It goes inside the quotes. You also need to delimit a date with #.

rs.Findfirst "[Job ID] = " & aJob & " AND [Date Type] = #" & aDate & "#"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

findfirst data type error 1
rs.FindFirst limits? 3
FindFirst - 2 criteria 10
How to create a bubble chart with more than 2 variables 0
Searching 10
Enter Parameter Values Problem 1
using combo boxes from form to select query criteria in reports 4
Recordset Findfirst Date Issue 0

Back
Top