Re: PLEASE HELP - I NEED AN EXPERT

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 05/18/04


Date: Tue, 18 May 2004 17:40:40 -0500

I expect that if you don't provide some sample data and expected output
format, you won't get too much help. Can you provide more specific
information?

-- 
Duane Hookom
MS Access MVP
"Stella" <Stellawilliamson@hotmail.com> wrote in message
news:9B655099-FA67-4739-9BC5-210B90222EAA@microsoft.com...
> I have using 3 systems that do not speak to each other.   Imported data
into access and joined.  Make a report putting in formulas etc working out %
against overall totals etc., but cannot Graph as the graph looks at the
query and NOT the report i have created.  Is there a way to create a graph
based on a report.???
>
> If not., how easy is it to work out in one single query what each person %
is against overall ie., if each person works between 7-9 hrs per day, and
overall total hours is 360, need to know each person percentage.
>
> Is this possible, option 1 above is preferable as work already done?


Relevant Pages

  • Re: Sum a Union Query
    ... >SELECT TrnDate, SalesOrder, - CancelledValue AS Cancels, LineType ... three totals, but the code you post doesn't include any SUM function. ... as based on the sample data you posted. ...
    (microsoft.public.sqlserver.mseq)
  • Re: how to convert rows to column in Access
    ... Totals: Group By ... Crosstab: Row Heading ... e.g. sample data is like: ...
    (microsoft.public.access.queries)
  • Ruport GraphReport
    ... graph a quick sample data i get richeous errors lol. ...
    (comp.lang.ruby)
  • Please help with date insertion
    ... Not very good with excel so hope you can help ... How can I have a graph that only takes the sample data from colummn B ... B&Cand a 7day graph from the last 7 entries ...
    (microsoft.public.excel.worksheet.functions)
  • Please help with date insertion
    ... Not very good with excel so hope you can help ... How can I have a graph that only takes the sample data from colummn B ... B&Cand a 7day graph from the last 7 entries ...
    (microsoft.public.excel)