Query between 2 dates via Calendar Controls

[MAVIS]

I am trying to construct a query so that when I click a Command Button it searches between 2 combo box dates which have Calendar controls on them, and returns records of all my Staff who joined our organisation between a selected time-frame. I only want it to search from one table called STAFF and one field within it called Date Joined. I have searched around for a solution, including this site but am still at a loss.I have cboStartDateSch and cboEnddateSch both of whom have calendar controls that work fine. Please accept my apologies as I am pretty sure that this question has been asked loads of times ? Can anyone please point me in the right direction as I believe that the only daft question is the one that isn't asked?


Many thanks


Mavis

 

[Mile-O]

Combos with calendar controls? What do you mean by this? Popups that get put into the combo?

THe criteria should be:

Between Format([Forms]![MyForm]![MyCombo1],"mm/yy/yyyy") And Format([Forms]![MyForm]![MyCombo2], "mm/dd/yyyy")

 

[MAVIS]

Combos with calendar controls? What do you mean by this? Popups that get put into the combo?

THe criteria should be:

Between Format([Forms]![MyForm]![MyCombo1],"mm/yy/yyyy") And Format([Forms]![MyForm]![MyCombo2], "mm/dd/yyyy")

Very many thanks for the prompt response - it works an absolute treat.
Hopefully one day i'll be able to grasp the concepts in full and be more of a
contributor toward the various forum's. Ta very much

Regards

Mavis