Prev: Sorting and Grouping
Next: How to reference main report field in subreport calculation
From: Al Campagna on 26 Apr 2010 15:26
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" <Stuart(a)discussions.microsoft.com> wrote in message
news:0D16D220-5E05-438B-B0EC-00618958AE43(a)microsoft.com...
> 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" <Stuart(a)discussions.microsoft.com> wrote in message
>> news:5E817937-C066-4BA0-9634-C279C5D3F946(a)microsoft.com...
>> > 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.
>>
>>
>> .
>>


First  |  Prev  | 
Pages: 1 2
Prev: Sorting and Grouping
Next: How to reference main report field in subreport calculation