strSQL = " (multiple criteria)

[Chrissy]

I am using a date criteria strSQL I got from here a while back. Works great!
Thanks.

Now I wish to add a second criteria to it. I am so lost.

Successful code:
strSql = "[StartDate] >= #" & CDate(Me!txtStartDate) & "# AND [StartDate] <
1+ #" & CDate(Me!txtEndDate) & "#"


What I would like to include above: And [CG1] = Me.txtCGID

This would limit results to the date range for the employee (CG1) selected.
Don't have a clue how to do this and cannot seem to find any examples.

Help?

 

[ken]

If CG1 is a number data type then:

strSql = "[StartDate] >= #" & CDate(Me!txtStartDate) & _
"# AND [StartDate] < 1+ #" & CDate(Me!txtEndDate) & _
"# AND [CGI] = " & Me.txtCGID

If it’s a text data type then:

strSql = "[StartDate] >= #" & CDate(Me!txtStartDate) & _
"# AND [StartDate] < 1+ #" & CDate(Me!txtEndDate) & _
"# AND [CGI] = """ & Me.txtCGID & """"

Ken Sheridan
Stafford, England