Trying to use Year as a variable

From: Anthony Viscomi (anthonyviscomi_at_msn.com)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 16:55:23 -0500

I am creating an Update Query that will filter by 2 dates using a Between
Statement. I have the Month & Days "hard coded" in as the criteria, but I
want the Year to be read in from an active form that contains the "year"
fiield. I thought that it should look like this:
Between 01/01 Forms![frmYear_Selector]![Combo0] and 01/31/
Forms![frmYear_Selector]![Combo0]

but that doesn't work.

Can someone please help?
Thanks
Anthony

Relevant Pages

  • Re: printing recordes viewed on screen
    ... If you are using an Update query to clear the selection, ... pick up the Filter property from your form, and use it in the WHERE clause ... Private Sub cmdSelect_Click ...
    (microsoft.public.access.queries)
  • Re: Update query and filter by selection
    ... Lasse T ... > Microsoft Security Bulletin MS03-026? ... > | I´m using filter by selection in a form. ... > | unwanted data i want to run an update query that updates one field based ...
    (microsoft.public.access.queries)
  • Re: Selecting records
    ... I'm already doing a filter on the subdatasheet: ... I would like to try and use an update query, but am stuck of how I can only ... >>can click to select or unselect the records. ...
    (microsoft.public.access.formscoding)
  • RE: Update query and filter by selection
    ... Microsoft Access Support ... Microsoft Security Bulletin MS03-026? ... | I´m using filter by selection in a form. ... | unwanted data i want to run an update query that updates one field based ...
    (microsoft.public.access.queries)
  • Re: Update query and filter by selection
    ... Dim strSQL As String ... Tips for Access users - http://allenbrowne.com/tips.html ... > I4m using filter by selection in a form. ... > apply the same filter in the update query. ...
    (microsoft.public.access.queries)