Re: Filtering problem

Tech-Archive recommends: Speed Up your PC by fixing your registry

You seem to be missing quotes at the beginning and end of the string.

Try:

="Uren.Datum > " &
Format(Forms![Uur_overzicht]!Start_dat,'\#yyyy\-mm\-dd\#') & " And
Uren.Datum < " & Format(Forms![Uur_overzicht]!Stop_dat,'\#yyyy\-mm\-dd\#)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jean-Paul" <jp.dewinter@xxxxxxxxxx> wrote in message
news:94ZZj.3689$zc6.3585@xxxxxxxxxxxxxxxx
I changed the line in filter-propertie to:
=Uren.Datum > #" & Format(Forms![Uur_overzicht]!Start_dat,'yyyy/mm/dd') &
"# And Uren.Datum < #" &
Format(Forms![Uur_overzicht]!Stop_dat,'yyyy/mm/dd') & "#

When the table is run, All records are displayed.
When I click the filter icon I get the errormessage saying there is an
operator missing in the query-expression.

What do I do to filter upon opening the form
What do I do about the eroormessage

Thank you so much
JP


Douglas J. Steele wrote:
Your dates are NOT "stored as dd/mm/yyyy". You may choose to display the
dates in dd/mm/yyyy format, but that has no bearing on how they're
stored.

Dates are eight byte floating point numbers, where the integer portion
represents the date as the number of days relative to 30 Dec, 1899, and
the decimal portion represents the time as a fraction of a day.

Read the two references which I cited.



.

Relevant Pages

  • Re: Time syntax help - Minutes & Seconds
    ... I was actually storing the duration as a 'number' and needed ... Date/Time fields are intended to store specific points in time (i.e.: ... field is an 8 byte floating point number where the integer portion ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.queries)
  • Re: time is equal
    ... where the integer portion represents the date as the number ... Doug Steele, Microsoft Access MVP ... (no private e-mails, please) ... gives me the client number and the timeout and the ...
    (microsoft.public.access.modulesdaovba)
  • Re: datediff("m",date1,date2)does not work on any date other than
    ... Doug Steele wrote. ... You specify how you want the difference between two date/times to be ... by 30 and take the integer portion of that to get the number of 30 day ...
    (microsoft.public.access.queries)
  • Re: Filtering problem
    ... but that has no bearing on how they're stored. ... Dates are eight byte floating point numbers, where the integer portion ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.formscoding)