findfirst - 2 search criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

liz - 29 Sep 2007 17:40 GMT

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.

Signature

thanks
liz

Reply to this Message

Rick Brandt - 29 Sep 2007 17:57 GMT

> 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
[quoted text clipped - 3 lines]
>
> i am not sure how to program the AND.

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

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

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message