Access

The UK's most regular instructor-led training courses.
Training information: microsoft+access+training+course · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2003

Access

Lisa has attended:
Access Advanced course

by - delegate Lisa [2 posts] (2008 Apr 30 Wed, 15:17) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 20 Mon + 21 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	6	book now	£450	£485
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 14 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Access

by - trainer Simon silver contributer [73 posts] (2008 May 1 Thu, 17:00) Reply

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

by - delegate Lisa [2 posts] (2008 May 2 Fri, 09:09) Reply

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

Regards Lisa

· MS Access: Access your Personal Information with Ease
· Reasons to Consider Microsoft Access Training
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Access VBA Training Adds Power to your Databases
· Access VBA Handling Errors and Debugging Code

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

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips