Query help, date criteria

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

Hi everyone,

Im newbie with access, how do I create a query that only report the records
in a specific month? BTW the table that i have records have a field of date
in format mm/dd/yy, i dont have any field with just the month.
Any help will be appreciated. thanks in advance

.

Relevant Pages

  • Re: remove fields from query without data
    ... The answer is you can't do this in any one query. ... You can choose which fields to display in each form and report. ... newbie wrote: ...
    (microsoft.public.access.modulesdaovba)
  • textbox controsource as recordset field
    ... I'm a newbie to Access 2000, trying to set up a report here. ... recordset with a query, and want to assign the result to a textbox on the ...
    (microsoft.public.access.reports)
  • Re: Query help, date criteria
    ... how do I create a query that only report the records ... BTW the table that i have records have a field of date ... in format mm/dd/yy, i dont have any field with just the month. ... Add a new column to the query grid. ...
    (microsoft.public.access.queries)
  • Re: Making invisible some information on a report
    ... >I'm a newbie and I've a report, from a query, that show me data from five ...
    (microsoft.public.access.reports)
  • use query parameter as a criteria in my report
    ... newbie to access, I have created a report, based on a query: ... The query parameter is well displayed in the report ... "January" (the value keyed in by the end user when launching the ...
    (microsoft.public.access.reports)