Rabu, 24 Oktober 2012

RE: [MS_AccessPros] Need help with Subtotal Query

 

Yes, you can send directly to me and I can share.

Duane


> To: MS_Access_Professionals@yahoogroups.com
> From: no_reply@yahoogroups.com
> Date: Wed, 24 Oct 2012 18:29:02 +0000
> Subject: Re: [MS_AccessPros] Need help with Subtotal Query
>
> Duane,
>
> I am at work and when I try to send a response to you with the SQL code the site crashes. Would it be alright if I respond through the Reply to Sender instead of Reply via web post?
>
> v/r,
> James Eggert
>
> --- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
> >
> > James,
> > The start of a "best approach" would be to:
> > 1) suggest why a datasheet must be used rather than a report
> > 2) provide your SQL views
> >
> > Duane Hookom
> > MS Access MVP
> >
> >
> > > To: MS_Access_Professionals@yahoogroups.com
> > > From: no_reply@yahoogroups.com
> > > Date: Wed, 24 Oct 2012 17:29:22 +0000
> > > Subject: [MS_AccessPros] Need help with Subtotal Query
> > >
> > > I have a requirement to analyze data by displaying a subtotal for 7 qty fields per month based on a date field (mm/yy). The subtotal row has to display at the bottom of each month in the datasheet view. I tried a Union Query, but I have to group the data off of three different fields which causes problems with the Union Query. Not sure what would be the best approach. Any help will be greatly appreciated!
> > >
> > > v/r,
> > > James Eggert
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>


[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
.

__,_._,___

Tidak ada komentar:

Posting Komentar