searching by date reference...

[ariel81]

Hi,

i have a START date "DD/MM/YYYY" <-- with 3 combo boxes "cboStartDD", "cboStartMM", "cboStartYYYY".

i have a END date "DD/MM/YYYY" <-- with 3 combo boxes "cboEndDD", "cboEndMM", "cboEndYYYY".

i have a Search command buttom.

upon a "search" button is click,

how can i search the dates in the table with "tblDate" (column) that matches the date ranges from the START date to the END date?

thank you.

 

[ShaneMan]

Hi,

i have a START date "DD/MM/YYYY" <-- with 3 combo boxes "cboStartDD", "cboStartMM", "cboStartYYYY".

i have a END date "DD/MM/YYYY" <-- with 3 combo boxes "cboEndDD", "cboEndMM", "cboEndYYYY".

i have a Search command buttom.

upon a "search" button is click,

how can i search the dates in the table with "tblDate" (column) that matches the date ranges from the START date to the END date?

thank you.

Hey Ariel,

You should be able to search this site and come up with lots of post to aid you. I did a quick search and found this one: http://www.access-programmers.co.uk/forums/showthread.php?t=135299&highlight=filter+dates

It really depends on how you want to search, what your search on, and etc. but no matter which way you go, your question has been asked before so you should find something that will pertain to what your trying to do.

Try searching criterias like: "filter using dates"; "BETWEEN", "StartDate"; "EndDate" & etc.

Let us know if your unsuccessful and I'm sure someone will lend a hand.

HTH,
Shane