UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Type Mismatch And Can't Figure It Out, Access 2010    
 
   
baffled100
post Nov 9 2017, 09:26 PM
Post#1



Posts: 343
Joined: 10-December 12



Hi,

I have such trouble with this......I can't figure out why I am getting a type mismatch error from this statement (app_period is a text field):

varx = DCount("id", "tbldwl", "[app_period]='" & Me![APP_PERIOD] & "'" And ([RESULT] <> "SPI" And [RESULT] <> "EMER"))

Thanks!
Go to the top of the page
 
baffled100
post Nov 10 2017, 08:47 AM
Post#2



Posts: 343
Joined: 10-December 12



Thank you so much! That did the trick!
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 06:08 AM