473,326 Members | 2,175 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

How do you do calculations in Access?

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
3 8046
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Ben McLaurin | last post by:
When oopeening a form based of a table I need to run a function to do some calculations. Which form event do I need to use that will automatcally run when the form is opened but all the data from...
2
by: brian kaufmann | last post by:
I'd appreciate your ideas on this. I need to make the calculation for unemployment rate for three different data sources (A,B,C) for many countries and age groupings: unemployment rate = number...
3
by: brian kaufmann | last post by:
Hi, I had sent this earlier, and would appreciate any suggestions on this. I need to make calculations for unemployment rate for three different data sources (A,B,C) for many countries and age...
3
by: John M | last post by:
Hi, I've been coming up against a failure of a report to display the result of a simple calculation. I have realised that this calculation cannot take place unless the field I am working on is...
6
by: migueltxa | last post by:
Hi all, I have a problem with some calculations in MS Access 2003. I have 3 fields (Qty, Price and VolumeUSD) in a form and the following formula: VolumeUSD = Qty * Price. Qty and VolumeUSD...
4
by: tlyczko | last post by:
Hello, I have read about currency calculations, etc. in this newsgroup, and I understand that currency math will be sufficiently accurate for what I need to do for a mileage/expense report. ...
2
by: Xeijin | last post by:
URGENT I have an assignment to hand in tomorrow, I need to know how to perform numeric calculations in access, I dont know very much about databases so consider this a beginner's query! Well...
4
by: debi.robarts | last post by:
Ok, in my database I have something like this: Date One # of Days to Next Date These calculate a field "Date Two." Because "Date Two" is an expression (calculated by the form), I can't set...
3
by: AZKing | last post by:
Hello, I am trying to create a query to calculate certain fields in from a table. The calculations are pretty simple, they are just counts and sums. Once I run it I get the following error...
1
by: Grubsy4u | last post by:
Grubsy4u Newbie 7 Posts October 5th, 2007 11:31 AM #1 Report calculations --------------------------------------------------------------------------------
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.