search query by date

From: George (anonymous_at_discussions.microsoft.com)
Date: 02/29/04 

Date: Sat, 28 Feb 2004 18:13:29 -0800

>-----Original Message-----
>For my computing coursework i have to build a stock
>control database, but although it is almost finished it
is
>missing the most important thing, and time is running
out
>so PLEASE HELP!
>
>I have got a query which orders both the delivery lines
>and order lines (both of which have dates) by the month.
>My user wishes to select a month from a combo box and to
>have the query show only what has gone in and out in
that
>month. Is this possible with only showing the months
with
>the information for which are continually changing, also
>both the delivery line and order line have dates on.
>
>Can anybody help?
>.
>

Not sure if i understand you right but here goes.

in your query set a field say selectmonth to

selectdate: Month([Datefield])

then in your form make sure your combo box format is the
same as your selectdate and put this in your criteria for
your query.

Hope this helps

Relevant Pages

  • Re: search query by date
    ... >control database, but although it is almost finished it is ... >missing the most important thing, ... >I have got a query which orders both the delivery lines ... >both the delivery line and order line have dates on. ...
    (microsoft.public.access.queries)
  • search query by date
    ... control database, but although it is almost finished it is ... missing the most important thing, ... I have got a query which orders both the delivery lines ...
    (microsoft.public.access.queries)
  • RE: Dispalying a months worth of records .. off one date
    ... you can kill me if dunb suggestion: ... What if in your query you add a column that shows the month of the date ... And then on your Selectdate form you make an unbound textbox ...
    (microsoft.public.access.formscoding)
  • Dispalying a months worth of records .. off one date
    ... On "SelectDate" form, I have where the user can select whatever date ... i want it to display a month's ... query for the form, but i'm not sure... ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: use combo box to filter data in a form
    ... I removed the parameter and criteria from the query as suggested. ... Private Sub cboFilterGroup_AfterUpdate ... The other code merely did a "Find" and not a FILTER. ... First, I created a select query called Delivery Summary ALL, which is ...
    (microsoft.public.access.reports)