If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
datediff
hi
I am trying to get a list of name who's birthday is 35 of days away. I have build a query with all of the information the I need. Under the field birth I enter the following criteria: IIf(DateDiff("d",[birth],Date())=35,[TITLE]+" "+[LNAME]," ") I get an error 3464 (Data Type Mismatch in criteria expression) In my table Birth is setup the following way: Date/Time Medium Date -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#2
|
|||
|
|||
datediff
You have entered this expression where? Are you wishing to filter your
records to only babies that are less than 36 days old? If so, create a new column in your query with an expression like: DaysOld: DateDiff("d",[birth],Date()) and set the criteria to =35 -- Duane Hookom Microsoft Access MVP "greenbg via AccessMonster.com" wrote: hi I am trying to get a list of name who's birthday is 35 of days away. I have build a query with all of the information the I need. Under the field birth I enter the following criteria: IIf(DateDiff("d",[birth],Date())=35,[TITLE]+" "+[LNAME]," ") I get an error 3464 (Data Type Mismatch in criteria expression) In my table Birth is setup the following way: Date/Time Medium Date -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
Thread Tools | |
Display Modes | |
|
|