A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Calculations Within the Report



 
 
Thread Tools Display Modes
  #1  
Old April 20th, 2010, 02:39 PM posted to microsoft.public.access.reports
Stuart
external usenet poster
 
Posts: 157
Default Calculations Within the Report

Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My problem
is that I cannot get them on one report. And finally I want to DATE Entered
query.
  #2  
Old April 20th, 2010, 03:31 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Calculations Within the Report

Stuart,
What is your table structure/s for the three forms.
One table? Three tables?
Please give us some detail about the important fields in your table/s

What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Stuart" wrote in message
...
Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The
fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My
problem
is that I cannot get them on one report. And finally I want to DATE
Entered
query.



  #3  
Old April 20th, 2010, 03:50 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Calculations Within the Report

I expect you want to create a union query like:
SELECT "Sales" as List, [Total Cost], [Tax]
FROM Sales
UNION ALL
SELECT "Expense", [Total Cost], [Tax]
FROM Expense
UNION ALL
SELECT "Purchases", [Total Cost], [Tax]
FROM [Purchase Order];

You haven't provided enough information about the DATE Entered to even guess
at what you mean.

--
Duane Hookom
Microsoft Access MVP


"Stuart" wrote:

Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My problem
is that I cannot get them on one report. And finally I want to DATE Entered
query.

  #4  
Old April 26th, 2010, 10:06 AM posted to microsoft.public.access.reports
Stuart
external usenet poster
 
Posts: 157
Default Calculations Within the Report

Thanks for the response, I have 3 tables that collect information on:
1. Sales.
2. Purchase Orders.
3. Expenses.

As these forms are seperate and each entery is DATE Entered specific I now
need to extract the information from each form and place them into one report
that queries each form DATE ENTERED Specific. This may cause me problems I
don't know.
After I exstract the information into the report I want to then calculate
Sales totals, Purchase Order Totals and Expenses to get TAX total.

Hope this helps you.
Cheers in advance. Stu

"Al Campagna" wrote:

Stuart,
What is your table structure/s for the three forms.
One table? Three tables?
Please give us some detail about the important fields in your table/s

What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Stuart" wrote in message
...
Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The
fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My
problem
is that I cannot get them on one report. And finally I want to DATE
Entered
query.



.

  #5  
Old April 26th, 2010, 04:53 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Calculations Within the Report

Did you try a union query as I suggested?

Could you answer Al's question? I can't pick out any field names from your
reply.

You stated: "information from each form"
Information is not stored in forms, it is stored in tables.

--
Duane Hookom
Microsoft Access MVP


"Stuart" wrote:

Thanks for the response, I have 3 tables that collect information on:
1. Sales.
2. Purchase Orders.
3. Expenses.

As these forms are seperate and each entery is DATE Entered specific I now
need to extract the information from each form and place them into one report
that queries each form DATE ENTERED Specific. This may cause me problems I
don't know.
After I exstract the information into the report I want to then calculate
Sales totals, Purchase Order Totals and Expenses to get TAX total.

Hope this helps you.
Cheers in advance. Stu

"Al Campagna" wrote:

Stuart,
What is your table structure/s for the three forms.
One table? Three tables?
Please give us some detail about the important fields in your table/s

What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Stuart" wrote in message
...
Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The
fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My
problem
is that I cannot get them on one report. And finally I want to DATE
Entered
query.



.

  #6  
Old April 26th, 2010, 08:26 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Calculations Within the Report

Stuart,
Read Duane's reply too... I think he may have been working with you
on a previous (different) post. So try to keep up with his posts too.

It's good to know the names of the 3 tables, but we really
need to know how the 3 tables are related, and whether they are related
one to many, or one to one, etc...
What is your table structure/s for the three forms.
Please give us some detail about the important fields in your table/s


What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?


There should be some unique common value between the 3 tables.
Like above... a StoreID, or a CustomerID, or a SalesRegionID... etc etc...

That would be the value that relates the 3 tables together in a Union query,
so that certain values from each table are available to be placed on the
report.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

"Stuart" wrote in message
...
Thanks for the response, I have 3 tables that collect information on:
1. Sales.
2. Purchase Orders.
3. Expenses.

As these forms are seperate and each entery is DATE Entered specific I now
need to extract the information from each form and place them into one
report
that queries each form DATE ENTERED Specific. This may cause me problems I
don't know.
After I exstract the information into the report I want to then calculate
Sales totals, Purchase Order Totals and Expenses to get TAX total.

Hope this helps you.
Cheers in advance. Stu

"Al Campagna" wrote:

Stuart,
What is your table structure/s for the three forms.
One table? Three tables?
Please give us some detail about the important fields in your table/s

What is the logical association between the 3 forms?
Does a particular Store have Sales, Expenses, POs?
Or... does an Region have Sales, Expenses, POs?
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."

"Stuart" wrote in message
...
Hi All,
My problem is that I have 3 Accounting forms:
1. Sales
2. Expenses
3. Purchase Orders

I now want to extract certain fields into one Tax Return Report. The
fields
will be to 1. Sales.Total Cost
2. Sales. Tax
3. Expense. Total Cost
4. Expense. Tax
5. Purchase Order. Total Cost
6. Purchase Order. Tax

Once all these are on the report I can then caluculate as I need, My
problem
is that I cannot get them on one report. And finally I want to DATE
Entered
query.



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:09 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.