G
Guest
I am having trouble retrieving all records between the first day and last day
of a month. I am using >=[StartDate]<=[EndDate] where [StartDate] and
[EndDate] are fields in a Table of all months with their first and last dates
listed. I have also tried 'Between [StartDate] And[EndDate]' Both of
these return results that do not include any records dated on the last day
of the month. I can't write code so can someone please give me a simple
answer. Some of the answers I see here in the discussion group I can't even
understand, let alone try and put into practice!
Thanks
mazbaz
of a month. I am using >=[StartDate]<=[EndDate] where [StartDate] and
[EndDate] are fields in a Table of all months with their first and last dates
listed. I have also tried 'Between [StartDate] And[EndDate]' Both of
these return results that do not include any records dated on the last day
of the month. I can't write code so can someone please give me a simple
answer. Some of the answers I see here in the discussion group I can't even
understand, let alone try and put into practice!
Thanks
mazbaz