Finding The date Of An Enquiry

[Keith Burgess]

Hi There,

I am an Access novice and have managed to create a DB to record all incoming enquiries to my business. The enquiries are entered via a form onto a table and one of the fields is the date of the enquiry, which is entered as 01-Jan-07.
What I want to do is build a query that will find all enquiries in a given month.
Has anyone got a simple soultion, please?

Best regards
Keith

 

[Michael J Ross]

A way would be to create a form where user enters a start date and end date in text boxes on the form. You would then reference this in your query using the following criteria under your date column

Between [Forms]![NameofyourForm]![NameofDatefromfield] And [Forms]![NameofyourForm]![NameofDatetofield]

If you add a button to your form you can use its On Click Event to run the query after the dates have been entered.

 

[KeithG]

MonthOfDate: Month(DatePart('m',[QueryDateColumn]))

usePaste the above as a query column and then make a parameterto enter the month name.

 

[Keith Burgess]

A way would be to create a form where user enters a start date and end date in text boxes on the form. You would then reference this in your query using the following criteria under your date column

Between [Forms]![NameofyourForm]![NameofDatefromfield] And [Forms]![NameofyourForm]![NameofDatetofield]

If you add a button to your form you can use its On Click Event to run the query after the dates have been entered.

Hi Keith,

Many thanks for this advice it's working well

Keith B

 

[Keith Burgess]

A way would be to create a form where user enters a start date and end date in text boxes on the form. You would then reference this in your query using the following criteria under your date column

Between [Forms]![NameofyourForm]![NameofDatefromfield] And [Forms]![NameofyourForm]![NameofDatetofield]

If you add a button to your form you can use its On Click Event to run the query after the dates have been entered.

Hi Michael,

Thank you for your help on this it has been most welcome
Keith B

 

[Michael J Ross]

Youre welcome Keiths is better, just a point Keiths query will pick up all records with say a month of Jan, so when you get records covering 2 or more years you'll need to specify the year also. This can be done in the same way as keith showed you, creating a year column replacing "m" with "yy".