473,322 Members | 1,352 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,322 software developers and data experts.

How to display code calculation results in a table???

Hi guys,

Hope to gather some information and help from all you experts out there.
I have VERY limited experience with Micorosft Access...

I have a form that displays the age of a customer taken from another field, (DOB).

The problem here is, this information is not visible in the table??

I also have ANOTHER field for class Totals, with the same setup...
I would also like to have this information visible in a table so that i can manipulate reports...

ANYWAY help will be greatly appreciated..

RAJ

--------------------------------------------------------------------------------
Mar 30 '07 #1
8 2718
Rabbit
12,516 Expert Mod 8TB
If they're calculations of fields in the table, there's no need for them to be in the table.

Just create a query that has these calculations and make a report on the query.
Mar 30 '07 #2
If they're calculations of fields in the table, there's no need for them to be in the table.

Just create a query that has these calculations and make a report on the query.
Sorry there Rabbit, not so sure what all this means, but i am trying to access that data in order to have it list on other forms/tables and use as a query. But since it isn't in any table, how can i do this??

Example, with the DOB, i would like to sort by age group....
With out the data been in a table, this becomes difficult...
Although it is listed on the form, it just doesn't show up in the coresponding table, which is left blank...

Same problem with another on my class table...
Trying to take the total number of students from a class, and have this information reflected on a report, but where do i pull this information from, once again. the coresponding table is blank?

Your help would be really great...

RAJ
Mar 31 '07 #3
MMcCarthy
14,534 Expert Mod 8TB
Total no of students per class would be something like ...
Expand|Select|Wrap|Line Numbers
  1. SELECT Class, Count(Students) As NoOfStudents
  2. FROM tblClass
  3. GROUP BY Class;
  4.  
Apr 1 '07 #4
Rabbit
12,516 Expert Mod 8TB
Sorry there Rabbit, not so sure what all this means, but i am trying to access that data in order to have it list on other forms/tables and use as a query. But since it isn't in any table, how can i do this??

Example, with the DOB, i would like to sort by age group....
With out the data been in a table, this becomes difficult...
Although it is listed on the form, it just doesn't show up in the coresponding table, which is left blank...

Same problem with another on my class table...
Trying to take the total number of students from a class, and have this information reflected on a report, but where do i pull this information from, once again. the coresponding table is blank?

Your help would be really great...

RAJ
Blank? So you didn't bind the form to the table?
Apr 1 '07 #5
Not sure whatthat means by binding forms to tables???
What i do know is that EVERYTHING else on the form is; i guess binded to the table except this data, the age??
DOB, name and so forth are all visible in the table but the clients age???
Although the age of the client is visible on the form, just can't figure that out??
Also have the same for class totals...
The totals are visble on the form, but not in the table??

Once again, your help would be very greatful..

RJ
Apr 3 '07 #6
Rabbit
12,516 Expert Mod 8TB
Not sure whatthat means by binding forms to tables???
What i do know is that EVERYTHING else on the form is; i guess binded to the table except this data, the age??
DOB, name and so forth are all visible in the table but the clients age???
Although the age of the client is visible on the form, just can't figure that out??
Also have the same for class totals...
The totals are visble on the form, but not in the table??

Once again, your help would be very greatful..

RJ
That's what I meant in the beginning. If you have DOB in your table then you don't need to store age in your table, you just calculate it when you need it.

The same goes for total. If you have all the fields you need to calculate the total stored in the table, then there's no need to store the total. Just calculate it when you need it.
Apr 3 '07 #7
Thanks heaps guys, i think i understand it a lot more now...
Still all new to this stuff...

RAJ
Apr 7 '07 #8
Rabbit
12,516 Expert Mod 8TB
Not a problem, good luck.
Apr 7 '07 #9

Sign in to post your reply or Sign up for a free account.

Similar topics

20
by: Xenophobe | last post by:
I have successfully converted the ASP code included in the following article to PHP: http://www.4guysfromrolla.com/webtech/040100-1.shtml As described the high and low latitudes and longitudes...
2
by: erica | last post by:
Hi, I am currently writing PHP code for some polling software. When someone votes, it stores their IP address in the database. From then on, they cannot vote in that particular poll, they only...
1
by: Herbert Chan | last post by:
Hello, I have a table that stores information about some yearly forecast output, and a form that shows the records. Recently, my boss wants to show the data on a quarterly basis. Although the...
143
by: suri | last post by:
Hello I downloaded glibc and tried looking for the code that implements the sine function i couldnt find the file. i went to the math directory and found math.h.. i guess that needs to be...
1
by: bigmaddaz | last post by:
Ok im designing an application for working out compount interest. The user starts the page, 3 prompts appear, one asking for money invested, next asking for rate of interest, and last one asking for...
1
by: erick-flores | last post by:
Hello all I have a linked table using ODBC. When I tried to do Count() and Sum() for this linked table (onw of the field in the table is name "total") the form takes forever to gives me the...
9
by: wparrott | last post by:
I have a table called tblPayScales. It has 5 fields: numRecID - record ID txtCLASSCODE - a 1 or 2 letter text value (A, B, C, BD, L, LT, etc.) numPAYSTEP - a number value 0-49 numSALARY - a...
4
by: murrayatuptowngallery | last post by:
I started a JS project (my first) a year or two ago, got distracted & am just now getting back to it. By luck I had somehow found a way to collect data with a form, perform calculations with...
11
by: mrking | last post by:
Hi, First time in the Java section here. I have an HTML form and a PHP script to do a simple calculation but it has to take me to a different page for the results. The calculator is really...
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...
0
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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.