473,396 Members | 1,770 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 975
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: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
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
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
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,...

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.