Where Clause works by itself but not together? Please Help...

[Gina Whipp]

Hello All,

Small problem, why does this work if I use one or the other in 'where
clause' but not both? Yes, the first part is numeric and the second part
text. I checked that twice. The error message I get is 'Type Mismatch'


DoCmd.OpenReport "rptCoverSheet", acViewPreview, , "[pID]=" &
Me![txtProjectID] And "[ikCode]='" & Me![cboIndexKeyID] & "'"


Thanks!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

 

[Gina Whipp]

Thank you John Spencer, 10.2.006 answer to someone else! Pardon me for not
looking first!

 

[Santa-D]

I found this when I was trying to find how to manipulate the WHERE
clause which helped.

http://www.w3schools.com/sql/sql_where.asp

 

[Tom Wickerath]

Hi Gina,

Try this:

DoCmd.OpenReport "rptCoverSheet", acViewPreview, , "[pID]=" &
Me![txtProjectID] & " And [ikCode]='" & Me![cboIndexKeyID] & "'"


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________