Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ccurt
-
Criteria question using iif statement
I'm new to this site, definitely deserves a star. Thanks again!- ccurt
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Criteria question using iif statement
Thanks, that works perfectly for what I need.- ccurt
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Criteria question using iif statement
Is there a reason I get no results in the date field using this statement for my criteria? I'm guessing something is wrong with my expression DatePart("d",date())=1 IIf(DatePart("d",Date())=1,>=DateSerial(Year(Date()),Month(Date())-1,1) And <Date(),>=DateSerial(Year(Date()),Month(Date()),1)...- ccurt
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Question Regarding (faq705-6950)
thread705-1479285 I have used the code from (faq705-6950) and I'm planning on sending around 14000 emails out to notify customers of an updated payment website address. I see that the customer emails are added to the Bcc area. My question is with 14000 customers will this be a problem? If so...- ccurt
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
