Re: report from more then 1 querie

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

My table looks like this:

Employees Net Income Etc...
Company A 10 158,757
Company B 7 169,587
Company C 6 143,002

One querie has:

Net Income Per Employee Etc...
Company A 15,875.70
Company B 24,226.71
Company C 23,833.67

Another querie has:

Average Net Income Per Employee
20,493.30

The report I want would have:

Company A Average
Net Income Per Employee 15,875.70 20,493.30
Etc...

Net Income per employee is only one of the many items i want to compair.


"Duane Hookom" wrote:

> I can't picture what you mean by "show each one of my clients to compair
> their income per employee to the rest of my clients". Do you even know what
> this would look like?
>
> Maybe you could type a few records from your table and expected results?
>
> --
> Duane Hookom
> MS Access MVP
> --
>
> "Michb16" <Michb16@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:029A4D08-89A5-45D4-A1F4-4BC2B5B1CFF0@xxxxxxxxxxxxxxxx
> > Is there a way to structure my table and queries to make it so i can
> > create
> > this relationship/report? Right now i have a table with such fields at
> > number of employees and income. I have created a querie to calculate
> > income
> > per employee for all my clients. i have also created a querie to
> > calculate
> > the average of my clients income per employee. i would like to have a
> > report
> > that i can show each one of my clients to compair their income per
> > employee
> > to the rest of my clients.
> >
> > "Duane Hookom" wrote:
> >
> >> We "can't seem to create a relationship between them" either because we
> >> don't have a clue regarding your table structures, queries, sample
> >> records,....
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >>
> >> "Michb16" <Michb16@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:0B38AF90-9FD1-421F-8293-353712076532@xxxxxxxxxxxxxxxx
> >> >I am trying to create a report compairing two queries. One querie has
> >> >data
> >> > in it from multiple clients (Data Querie) and the other is the average
> >> > of
> >> > each line item being compaired in the data querie. How can i create a
> >> > report
> >> > with those two columns. I can't seem to create a relationship between
> >> > them.
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: report from more then 1 querie
    ... If there is only one record in the "Another querie" then you can add this ... > Net Income per employee is only one of the many items i want to compair. ... >> their income per employee to the rest of my clients". ...
    (microsoft.public.access.reports)
  • Re: report from more then 1 querie
    ... I can't picture what you mean by "show each one of my clients to compair ... their income per employee to the rest of my clients". ... I have created a querie to calculate ...
    (microsoft.public.access.reports)
  • Re: report from more then 1 querie
    ... I have created a querie to calculate income ... the average of my clients income per employee. ...
    (microsoft.public.access.reports)
  • Re: Cell Phone Tracking
    ... The Wikipedia entry is, on it's face, not specifying a median, ... and includes non-working household members. ... It's from a line labelled "Income per household member," ... was a federal employee for many years. ...
    (rec.arts.sf.fandom)
  • Re: Bush depression (was Re: AKICIF: Selling a letter)
    ... You can either use the cost to the employee OR you need ... to add the money the employer pays for insurance to the income of ... I'm sure those income numbers included *total* compensation, ... if you exclude government employees. ...
    (rec.arts.sf.fandom)