Grouping data within a group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access. I have joined 4 sreadsheets into one. I have created a
group of all jobs that have the data of job and job name, income, expenses
and total each jobs shows total for income and expenses from jobs in all
spreadsheets. From the union table I want to summerize activity within each
spreadsheet.
Example: Each spreadsheet has common fields but i want to group the activity
in each spreadsheet of 4 fields.
JOB NAME
ACCT 1 INCOME EXPENSES TOTAL
ACCT 2 INCOME EXPENSES TOTAL
ACCT 3 INCOME EXPENSES TOTAL
ACCT 4 INCOME EXPENSES TOTAL
JOB TOTAL
I JUST NEED TO KNOW HOW TO SEPERATE THAT DATA. THERE IS A FIELD IN EACH
SPREADSHHET BY LINE THAT IDICATES THE SPREADSHEET
 
I am new to Access.
You explaination is all about spreadsheets which is an Excel term. Access
has tables for storing data. Are you asking how to do something in Access or
Excel?
If your question has to do with Access then you need to tell the table and
field names, their datatype, and relationship.
 
Yes, all streadshhets have been combined into one union table all information
is on that one table. Job name, Acct, income, and expenses. I have everything
created except how to create a breakdown of expenses and income per account.
 
I have everything created except how to create a breakdown of expenses and
income per account.
This query will rollup the expenses and income by account ---
SELECT Your_Table.Acct, Sum(Your_Table.income) AS SumOfincome,
Sum(Your_Table.expenses) AS SumOfexpenses
FROM Your_Table
GROUP BY Your_Table.Acct;
 
I have created a report in Access. I am using a union table. The report gives
me jobs and combined expenses and income as a sum total from various accounts
in the union table. I want the report to tell me the expenses and income to
each job separated by account. I am new to Access and asked this question but
was probably not clear
 
Back
Top