Re: Date filter

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Waheeda Ali wrote:

I am running an apend query in access 2003 to analyze data from an outside
database. I am converting a non date string to date value with the following
expression in my sales date field in the query.
DateValue(Format([datestring],"@@@@/@@/@@"))

It is working fine, now I want to filter the dates and only wants records
after 12/31/2002. I had to leave the field type to "TEXT" in order for this
expression to work. Now I can't figure out how I should add the filter.


Use your conversion expression in a blank column to create a
calculated field. Uncheck the Show box and set the new
field's criteria in the usual way.

--
Marsh
MVP [MS Access]
.

Relevant Pages

  • Re: How to replace "Blank" With "0"
    ... The filtered query across all fields are none. ... I have a Sales query. ... I wanted to filter sales details for this particular ... choose a default date and surround my date field with NZ ...
    (microsoft.public.access.queries)
  • Re: Converting Text Date to Real Date to #
    ... In a query, you would have something like the following as a calculated field. ... Another possibility is not to bother converting the ages at all and using criteria to filter directly on the date of birth. ... I want to be able to have a field that calculates a persons age based on the current date and then filters the age to only include patients in a certain age range. ...
    (microsoft.public.access.queries)
  • Re: summing number of date entries in current week
    ... With my existing query in mind, I now also need a way to filter the ... results by sales person, eg: sum all the entries by current date, ...
    (microsoft.public.excel.worksheet.functions)
  • Filter
    ... I have a form based on query that filters on a user’s Sales ID, when opens. ... record is found and a filter is applied to get just the ones for forecast (10 ...
    (microsoft.public.access.formscoding)
  • Re: VBA Question sending reports
    ... make your report based on a query, before sending report build query SQL, filtered by sales rep and then send report ... and the other has a filter, that is supplied by a drop down in a form. ... made only two reports so i didn't have a seperate report for each sales rep. ...
    (microsoft.public.access.modulesdaovba)