How to create a date range form in Microsoft Access

[@ITsEasyTraining1st]

How to create a date range form in Microsoft Access. Check out courses at www.itseasy.co.uk

[@GregPlummer1962]

I like your teaching style. It has helped me a lot in such a short time. I am now a joined member...

[@ITsEasyTraining1st]

thanks

[@thedave1602]

Thanks! This was exactly what I was looking for. Spent way too long looking for this exact thing.

[@ITsEasyTraining1st]

Glad I could help!

[@PatriceMathieu-cp4vc]

You're a legend, thank you!

[@ITsEasyTraining1st]

You're welcome!

[@quyethongnhat3452]

Thanks! This is exactly what I am looking for

[@ITsEasyTraining1st]

Great to hear!

[@EasyMSAccess]

Thanks for this

[@ITsEasyTraining1st]

No problem

[@Albertbullterrier]

Great and useful

[@ITsEasyTraining1st]

Thanks

[@talosan9020]

Nice one.

[@ITsEasyTraining1st]

Thanks!

[@grannysaxton9568]

Cool thanks

[@ITsEasyTraining1st]

No problem

[@libreofficetutorials9499]

Great idea

[@ITsEasyTraining1st]

Thank you! 😊

[@edgarallen645]

Really good instruction video but one criticism..... slow down.

[@ITsEasyTraining1st]

will do

[@amrelnaggar4509]

I need your help, if I have a table with data entry form. This table contains fields (Order date, Total cost, first payment, second payment, Rest and paid date). Rest= Total cost - first payment - second payment. what I need is to have the paid date (now date when the order is paid) filled automatically under only two conditions, when the Total cost > 0 and Rest =0 (which means that the order is paid). Also how to prevent order modification after it is paid. Would you help me with that , please.

[@ITsEasyTraining1st]

you could use a tick box for date paid and then a formula to check whether it is ticked or not and if it is put the Now() function in the field if paid. You can set fields to password in properties.

[@amrelnaggar4509]

@@ITsEasyTraining1st ok.... I check that solution....thanks for help

[@vladstefan-claudiu8555]

When using the exact same formula for query, but inside a IIF statement as the value returned when true, it is not working. Do you have any idea why?

[@ITsEasyTraining1st]

could email an example

[@akokohjoel9854]

Pls I have a problem, how can I make a closing balance become the opening for next month. Pls help

[@ITsEasyTraining1st]

In Access or Excel

[@akokohjoel9854]

@@ITsEasyTraining1st ms access

[@afnanafif2895]

xie xie

[@ITsEasyTraining1st]

cool