Prev: select queries that calculate the Median base on group by
Next: Creating Bank Query
From: Charlie on 11 Mar 2010 16:24
Hi,

I need to find the total sales for a customer, I have tried the Group by
function but it just groups the company name in ascending order. My fields
are: Client_Name, Rep, InvoicePeriod, InvoiceYear, Total
I will also need to group by Invoice Period in relevant year.

Any help would be appreciated,

Thanks in advance.

Charlotte
From: Duane Hookom on 11 Mar 2010 16:39
You can't group by customer since you don't list a customer field.

--
Duane Hookom
MS Access MVP


"Charlie" <Charlie(a)discussions.microsoft.com> wrote in message
news:47F4A6AC-2594-4A59-BB4E-1090A20B424C(a)microsoft.com...
> Hi,
>
> I need to find the total sales for a customer, I have tried the Group by
> function but it just groups the company name in ascending order. My
> fields
> are: Client_Name, Rep, InvoicePeriod, InvoiceYear, Total
> I will also need to group by Invoice Period in relevant year.
>
> Any help would be appreciated,
>
> Thanks in advance.
>
> Charlotte

From: kc-mass on 11 Mar 2010 22:35
Hi Charlie,

I think you want to Group by Client_Name, InvoiceYear and InvoicePeriod and
then
sum your Total.

Regards

Kevin



"Charlie" <Charlie(a)discussions.microsoft.com> wrote in message
news:47F4A6AC-2594-4A59-BB4E-1090A20B424C(a)microsoft.com...
> Hi,
>
> I need to find the total sales for a customer, I have tried the Group by
> function but it just groups the company name in ascending order. My
> fields
> are: Client_Name, Rep, InvoicePeriod, InvoiceYear, Total
> I will also need to group by Invoice Period in relevant year.
>
> Any help would be appreciated,
>
> Thanks in advance.
>
> Charlotte


From: Charlie on 13 Mar 2010 06:42
Thank you for coming back to me, I am running Access 2002 at work and it
just was not doing it, however running the query at home on a 2007 version
gave me the exact results I was looking for.

Charlotte

"kc-mass" wrote:

> Hi Charlie,
>
> I think you want to Group by Client_Name, InvoiceYear and InvoicePeriod and
> then
> sum your Total.
>
> Regards
>
> Kevin
>
>
>
> "Charlie" <Charlie(a)discussions.microsoft.com> wrote in message
> news:47F4A6AC-2594-4A59-BB4E-1090A20B424C(a)microsoft.com...
> > Hi,
> >
> > I need to find the total sales for a customer, I have tried the Group by
> > function but it just groups the company name in ascending order. My
> > fields
> > are: Client_Name, Rep, InvoicePeriod, InvoiceYear, Total
> > I will also need to group by Invoice Period in relevant year.
> >
> > Any help would be appreciated,
> >
> > Thanks in advance.
> >
> > Charlotte
>
>
> .
>
 | 
Pages: 1
Prev: select queries that calculate the Median base on group by
Next: Creating Bank Query