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.