RE: Parameter query......query!

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

Just the month - easy! In the column of the query bring down your date field
and modify it to look like so:
TheMonth: Month([YourDateField])

In the Criteria put the following with the brackets:
[Enter the Numerical Month]

Run it and enter the number 1 which will give you any records created in
January. Any records from January. Doesn't care about the year.

Is any year a problem? Would you like typing in "June" instead of 6? How
about something like "June" and "2005" ? Just let us know.
--
Cheers,

Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"k.roberts@xxxxxxxxxx" wrote:

> Hi
>
> I am looking for some assistance.
>
> My end result is a report that will display records for a certain
> month.
>
> I need to create a parameter query that prompts the user to enter a
> month or maybe select from a drop down list. This is qhat I need help
> with - specifically what I need to enter as criteria in the Date field.
>
> Then I will attach this query to a report, so when the user clicks on a
> command button to run a report, they are prompted to enter the month
> required, then the report is displayed with the corresponding records
> from that month.
>
> Any help given would be greatly appreciated.
>
>
.

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: Fields in Label dont give correct information
    ... You need to create a query based on tblRegEvent and tblRegPayment. ... -If your DCountis to count values in your report, ... half the time with very few errors (other than that label problem I had.) ... For example in the Room assignment on the report an idividual will be ...
    (microsoft.public.access.reports)
  • Re: Tips on domain aggregate replacements
    ... This already is a split db, but the users are 400 miles away from the server hosting the data:) They are all running the same copy of the FE locally on a single terminal server via TS/RDP sessions. ... It doesn't seem to have much impact on performance; the report takes just about as long to run if they are all logged in as it does when I am logged on testing it at night. ... I would do DSums from the controls on the report on the data returned by the query. ... The biggest offender is a certain report that needs to Sum a particular complex total for each of the next twelve months (the DSum in VBA was a sideline to this issue) and present these as items on each line of output. ...
    (microsoft.public.access.modulesdaovba)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)
  • Re: using a form with combo box to input criteria
    ... Candia Computer Consulting - Candia NH ... When you removed the criteria, ... Then your criteria in the query would be... ... query behind your main report. ...
    (microsoft.public.access.forms)