access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

resolvedResolved · High Priority · Version 2003

Lisa has attended:
Access Advanced course

Access

I have an access database and need to create calaculate field against dates entered e.g. count number of days between two dates. The database has a data entry form. Is it best to do the calculations in a query or in the form?

RE: Access

Hi Lisa,

You could do it either way. Personally, I would create an unbound control in design view of the form using the toolbox. Then right click over the control and select properties. Go to the data tab and then click on the ... next to Control Source and you can build your formula from there using the fields in your form or from any of the tables.

I hope this has answered the question.

Regards

Simon

RE: Access

Thanks Simon. I thought it might be the best way but wanted to be sure.

Regards Lisa


 

Access articles

Please browse our web site to find out more about
microsoft+access+training+course and other training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.08 secs.