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
--------------------------------------------------------------------------------
8 2718
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.
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
Total no of students per class would be something like ... -
SELECT Class, Count(Students) As NoOfStudents
-
FROM tblClass
-
GROUP BY Class;
-
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?
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
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.
Thanks heaps guys, i think i understand it a lot more now...
Still all new to this stuff...
RAJ
Not a problem, good luck.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
| |