Search results

I get a box appear asking me to input todays date... I was hoping not to get the box and for it auto calculate using the date I run the report. How can I do this? Please confirm Thanks

am gonna test that right now... cheers

thanks guys... I knew the first part i.e. auto format... However need more advice on the "date diff" command please? Do I setup a query and run "date diff" from there or do I setup an expression? Please help Cheers

Hi there, I have setup a report in access, the field already has a date within it, I would like that date to go red 7 days before the due date. So when I run the report I can easily view which dates are due to expire 7days from today. How can I set this up? Please clarify which formulas or...

hey guys, thanks for your responses... can I request you treat me as a total newb at this stage and therefore kindly spell out which tables I will need based on my above physical example attached. Also please clarify which fields each table should have and the which field would be the...

that would be terrific - thank you very much... I was thinking of having 4 -5 tables as follows:- - driver table i.e. name , address , dob etc - Insurance table i.e. insurance company name, start date, expiry date - car table i.e. license no, start date, expiry date, - vehicle table...

Hi there, I decided to learn MS Access so having read many tutorials and guides I wanted to try to create my first database. "I am confused about how best to set up relationships in Access" As I am in the transport industry I thought I would try and create a database to help me automate...