Date range

[mabaker]

I have a form that the user can choose a date range, but the 'to date' field and the 'from date' field are dropdown boxes that contain the following: NovPrev;DecPrev;January;February;March;April;May;June;July;August;September;October;November;December;JanNext;FebNext.

There is a filed called 'payments' that puts an 'x' if a payment was received in that month (0 for no payment)

So, if a user chooses NovPrev - April for example, the report will show only those months and either an 'x' or 'o' for each month in the range.

Can anyone help me with this?

 

[ColinEssex]

What exactly is the problem?

Col

 

[mabaker]

I'm not sure how to do the call to the database to get records between JanPrev - October for example

 

[AN60]

Have you considered Mile O's calendar to select the dates?