By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,073 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,073 IT Pros & Developers. It's quick & easy.

How do you do calculations in Access?

P: n/a
I've been programming in Filemaker and am used to having a field type
called Calculation. An example of a calculation: In a school
registration database I have a date field corresponding to the start of
a quarter. I create a Calculation field to automatically generate a
human readable text string that looks like 'Spr 2005, Wi 2005, etc'.

Is there a way of doing this in Access?

Thanks,
Kevin

Nov 15 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
au******@quasika.net wrote:
I've been programming in Filemaker and am used to having a field type
called Calculation. An example of a calculation: In a school
registration database I have a date field corresponding to the start
of a quarter. I create a Calculation field to automatically generate a
human readable text string that looks like 'Spr 2005, Wi 2005, etc'.

Is there a way of doing this in Access?


In Access (and most other databases) you would do this only in a query,
form, or report. Never in a table. If you do it in a query it would then be
available for any form, report, or other process so that is the closest
thing to what you had in Filemaker.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 15 '05 #2

P: n/a
In message <11*********************@g44g2000cwa.googlegroups. com>,
"au******@quasika.net" <au******@quasika.net> writes
I've been programming in Filemaker and am used to having a field type
called Calculation. An example of a calculation: In a school
registration database I have a date field corresponding to the start of
a quarter. I create a Calculation field to automatically generate a
human readable text string that looks like 'Spr 2005, Wi 2005, etc'.

Is there a way of doing this in Access?


What you would usually do, if you use the same calculated field a lot,
is create a query based on the underlying table. That means that you
only need to write the code in one place and you can use it in any
number of forms and reports.

Alternatively you could use a lookup table and create a query that
includes data from your master table and the lookup table.

Remember too that you can write complex user-defined functions in
Access. Having written the function you can call it from code on a form
or even in a calculated field of a query.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author.

Nov 15 '05 #3

P: n/a
After you have looked at the other two posts, use the & to concatenate.
For example if you have two fields: Quarter, Semester. [Quarter] &
[Semester] will stick them together.
Pachydermitis

Nov 16 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.