If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculated fields
hi everyone. I know this a topic that has been discussed before but i
search all postings and i can't found an answer to my problem.I know a litle vba and access and i trying to do a calculated field.Here is my problem: I need to calculated the hours spent in a service call,and the hours spent biweekly. THis data have to be stored in a table so i can retrieve it monthly. How i can do it. Thanks and sorry to ask this again. |
#2
|
|||
|
|||
Calculations should be performed when needed in relational databases. Thus,
unless the information from which the "hours spent in a service call" and "hours spent biweekly" is no longer available, you should calculate the values when you need them, monthly. "Calculated Controls" cannot be bound to a Field in a Table for that reason -- it is a violation of relational database design practices. Larry Linson Microsoft Access MVP "Chely" wrote in message oups.com... hi everyone. I know this a topic that has been discussed before but i search all postings and i can't found an answer to my problem.I know a litle vba and access and i trying to do a calculated field.Here is my problem: I need to calculated the hours spent in a service call,and the hours spent biweekly. THis data have to be stored in a table so i can retrieve it monthly. How i can do it. Thanks and sorry to ask this again. |
#3
|
|||
|
|||
so, how i can sum all hours spent biweekly in a query? I type in the
query Field Total:Sum([Working Time]) and in Total Expresion and what it does is repeat the data in that record. What i have done wrong? Thanks |
#4
|
|||
|
|||
"Chely" wrote in message
oups.com... so, how i can sum all hours spent biweekly in a query? I type in the query Field Total:Sum([Working Time]) and in Total Expresion and what it does is repeat the data in that record. What i have done wrong? Thanks To sum records in a query, use the DSum function. You also have to specify what table to sum. Check help for other options with this function Tom Lake |
#5
|
|||
|
|||
A Totals Query with a date range as its critieria (the WHERE option) should
do what you want, as could the DSUM statement that Tom suggested (if you need it in VBA code). Larry Linson Microsoft Access MVP "Chely" wrote in message oups.com... so, how i can sum all hours spent biweekly in a query? I type in the query Field Total:Sum([Working Time]) and in Total Expresion and what it does is repeat the data in that record. What i have done wrong? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum of Calculated fields in Pivot Table | Graham | General Discussion | 0 | July 4th, 2005 03:47 PM |
filtering calculated fields | Dave | Running & Setting Up Queries | 3 | May 19th, 2005 12:06 PM |
Using calculated fields or Date Serial functions | Mon | General Discussion | 1 | May 3rd, 2005 04:17 PM |
calculated fields in query in secondary calculation | pruaccess | Running & Setting Up Queries | 1 | April 12th, 2005 03:48 AM |
Problem with calculated controls with data from subforms | Ragnar Midtskogen | Using Forms | 8 | July 25th, 2004 07:18 PM |