Recent content by ckitzman

naw, i got it. thanks. I was trying to do too many things in one query. I separated the steps out and it's working fine now. Thanks

Like this?: DOB: Mid([date_of_birth],5,2) & "/" & Mid([date_of_birth],7,2) & "/" & Mid([date_of_birth],1,4) I have this in the same query. I'm not familiar with DateSerial, sorry.

age: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")) Dob is stored yyyyddmm I thought this above function looks ok. When I run it, I get a data type mismatch in criteria expression. What am I missing? Any help would be appreciated. Thanks

lots of customers. lots of orders. i need to query for the first order of each customer only. thoughts?

Thanks everyone.

Thanks a bunch for the input. So far, just using a short date format Ex. Between #mm/dd/yy# And #mm/dd/yy# seems to work. I have to check through the recordset all the way but so far it seems to be working.

Thanks. Access isn't storing the data. I'm using Access to query a SQL database through linked tables I cannot make modifications to the SQL storage procedure. --ck

Thanks. the date is stored in SQL just as it appears above. When I run a parameter query for encounters I KNOW are in there, I get nothing. I'm thinking that becasue I'm not including the time portion in the parameter. Between [Enter Beginning Date of Report] And [Enter Ending Date for Report]...

I'm trying to extract data from a SQL table that has the date timestamp datatype. so it looks like this: 2005-03-29 16:57:06.007 How can I query for a date range while ignoring the time part of the stamp. EX. a parameter query for a month worth of encounters using the above date format...

I've set up command button to email a snapshot result of a query. Is there a way to populate the subject line of the email relative to the query. ex. I query for lname, fname, and cust# and other data for a report. The mail button throws a snapshot attachment into an email, I'd like the...

Same prob - What did you use What tool did you find/use?

I'm trying to make changes to records that are 3 years old. The date format is text and it displays as Ex. "20020831" or yyyymmdd. i try <"20020101" but I get no results and I know there should be. I'm a rookie and only know how to query using short date format. ideas anyone? thx