I have an Access 2013 database containing a number of unique ‘Clients’ and each client has multiple events attached including the date of the event (actually it is the date the information was received). Currently there are 4000+ events for 100+ clients.
I am having difficulty with a query in producing a list of events for a single client between two dates, the client is selected from a listbox on a form.
My problem is that the query will not include any data from the current year.
In the query’s field for Client criteria I have:
[forms]![frmMain]![List3]
To isolate the records for the client highlighted in the listbox, in the field DateReceived criteria I have:
Between [Forms]![frmMain]![FirstDate] And [Forms]![frmMain]![SecondDate]
As long as I have a date prior to 1 Jan 2015 in the ‘firstdate’, the query will produce all events for the selected client before 1 Jan 15 (none for the current year).
I have tried several ‘combinations’ including using < and > but cannot understand why the events from 2015 are not listed. The form containing the listbox has the two unbound text boxes (Date Fields) [FirstDate] and [SecondDate] and has an entry in each when I run the query.
Thanks
Allan
I am having difficulty with a query in producing a list of events for a single client between two dates, the client is selected from a listbox on a form.
My problem is that the query will not include any data from the current year.
In the query’s field for Client criteria I have:
[forms]![frmMain]![List3]
To isolate the records for the client highlighted in the listbox, in the field DateReceived criteria I have:
Between [Forms]![frmMain]![FirstDate] And [Forms]![frmMain]![SecondDate]
As long as I have a date prior to 1 Jan 2015 in the ‘firstdate’, the query will produce all events for the selected client before 1 Jan 15 (none for the current year).
I have tried several ‘combinations’ including using < and > but cannot understand why the events from 2015 are not listed. The form containing the listbox has the two unbound text boxes (Date Fields) [FirstDate] and [SecondDate] and has an entry in each when I run the query.
Thanks
Allan