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

Add new field that adds two existing fields

Hello,

Please see data below:

CC DEPT_DESC EXPNS_CAT SumOfACT SumOfBUD
4490 Environmental Svcs EB 147331.21 117222
4490 Environmental Svcs PAYROLL 283884.05 234392

I want to have a field in my table that combines SumofAct and SumofBUD for EB and Payroll for same CC (4490). I need to do this for 10 other CCs. How can I build this in query? please help
Feb 27 '15 #1
3 977
twinnyfo
3,653 Expert Mod 2GB
First I would recommend not adding an extra field in your table for this.

Second, the way to do it in a query is using an aggregate query, summing those fields and grouping on the CC, Dept and ACT.
Feb 27 '15 #2
@twinnyfo
I tried what you said. It didn't work. See my screenshot.
Attached Images
File Type: jpg Untitled.jpg (13.8 KB, 108 views)
Feb 27 '15 #3
twinnyfo
3,653 Expert Mod 2GB
You must describe what "It didn't work" means otherwise we have no where to start.

It is difficult to tell if ACT and BUD are Account numbers or values that must be added together.
Mar 2 '15 #4

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

Similar topics

2
by: Joe User | last post by:
This may sound silly, but is it possible to build a query to generate a list of fields in a given table? TIA Joe
1
by: Tony | last post by:
Hi, I have an ID text field that is composed of two alphabetical letters and the rest are numbers. This field is also a primary key. In this same table, I want to separate this field into two...
5
by: helpless | last post by:
Access 2003 - Is there any way to copy/drag data from one field to multiple fields in the same column?
1
by: ROYALTECH | last post by:
I have to create the new field in existing table in ms access through vbcoding once new field is created in one name it should check new field is added or not. if new field is not in that table...
2
by: andy.bayley | last post by:
Hi - and thanks for reading this. I'm setting up a scheduled routine which links to an existing file. It's bringing in one field which has at least 2 and maybe 10 'words', separated by spaces,...
8
by: Elfae | last post by:
I have searched high and low for a sample for this, and I just can't find any. Sorry for the length! Background Information The issue revolves around setting up a system-generated increase in...
1
MindBender77
by: MindBender77 | last post by:
Hello Again All, I have a memo field that is backslash delimited. I am attempting to break up this field into individual fields. Ex (memo field). \John L. Doe\\StreetName RD\\City, Pa 11111 ...
9
by: deanvilar | last post by:
Gurus, how to query Select Distinct field + showing other fields? e.g.: SELECT DISTINCT assetMovementTable.assetNo, assetMovementTable.moveCode, assetMovementTable.compCode,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.