Search results

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?

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...

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