Date as Parameter in a Query

[tabaki]

I have a report that gets his information from a query filtered by a form. I filter by changing the query, by changing the parameters. I have succeed to filter by a textfield, but I can't succeed on a datafield (general type: dd/mm/yyyy hh:mm:ss). Always I get error 3075
Please help me

dim FilterString as string
FilterString = " Where TblInterventie.[Einde herstelling])=#" & [Forms]![FrmOproepen]![SubFrmInterventies].[Form]![Einde herstelling] & "#"
SQLstring = SQLstring & FilterString
MakeQueryDef("QRY RPT Afmelding", SQLString)

 

[SkipVought]

Hi,

When you execute a query that has a Where Clause that equates a Date/Time field to ONE SPECIFIC Date/Time value, in this case to the nearest SECOND, if your field does not contain THAT EXACT Date/Time value, you will get no resultset.

It it more usual to define a RANGE of Date/Time like this...

FilterString = " Where TblInterventie.[Einde herstelling]) BETWEEN #" & [Forms]![FrmOproepen]![SubFrmInterventies].[Form]![Begin herstelling] & "# AND #" & [Forms]![FrmOproepen]![SubFrmInterventies].[Form]![Einde herstelling] & "#"

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[LonnieJohnson]

At what line is the code breaking? Also what is the actual message associated with the error code?

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[dhookom]

You also should specify a U.S. date format in your queries. Check out Allen Browne's page at

http://www.allenbrowne.com/ser-36.html

Duane MS Access MVP
Now help me support United Cerebral Palsy