Re: Monthly activity report
From: JLF (jfee-nospam_at_yahoo.com)
Date: 02/01/04
- Next message: Allen Browne: "Re: How to tell what query an existing report is referencing?"
- Previous message: KB: "How to tell what query an existing report is referencing?"
- In reply to: Douglas J. Steele: "Re: Monthly activity report"
- Next in thread: John Spencer (MVP): "Re: Monthly activity report"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 01 Feb 2004 13:19:42 GMT
Thanks Doug,
But what i'm still puzzled about is how to create the report that will count
the right number of transactions.
For instance, even with the "month" table,
each member record has 3 dates. A member could have joined in 1/03, made a
donation in 5/03, renewed in 12/03.
So if i run a report to group by month, and show count of matching record,
I can only link 1 date field. The others get counted whether or not they
match the Month.
(eg. for instance I just mentioned, my report shows JAN-03 New members 1,
donations 1, renewal 1. Even though the donation and renewal are in may and
dec, they get counted in Jan along with the new members (date joined
field). )
Is what I'm trying to do feasible within normal queries/reports? or am I
getting into writing VBA code here?
If you or anyone else here has further suggestions, I'd really appreciate
it.
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:uElUj%23E6DHA.1636@TK2MSFTNGP12.phx.gbl...
> Queries can't retrieve data that doesn't exist, unfortunately.
>
> The easiest (and possibly only) way is to create a table that has one row
> for each month of interest, and join that table to your other queries. Use
a
> Left Join to select each row in the month table and all matching rows in
the
> other tables.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
>
> "JLF" <jfee-nospam@yahoo.com> wrote in message
> news:2aWSb.67938$U%5.383996@attbi_s03...
> > I've been scouring these ng's for days trying to find something that
would
> > help me with this.
> >
> > I have a database which tracks peoples' membership for a non-profit
> > organization.
> > I have fields for Date Joined, Date Renewed, Date of Donation (if the
> > member has made any charitable donations to the organization.)
> >
> > I;m trying to create a report which shows the the totals by month of
> > # new members (ie date joined is within the month)
> > # renewals (date renewed is within the month)
> > # donations (donation Date is within the month)
> >
> > I was able to create 3 separate queries, which sortof get the data, but
> they
> > only work if the date exists. (for instance, if there was no renewal in
> > October 03, the report/query would just skip October 03, rather than
show
> a
> > zero value.
> >
> > Any thoughts on how to do this?
> >
> > Thanks
> >
> >
>
>
- Next message: Allen Browne: "Re: How to tell what query an existing report is referencing?"
- Previous message: KB: "How to tell what query an existing report is referencing?"
- In reply to: Douglas J. Steele: "Re: Monthly activity report"
- Next in thread: John Spencer (MVP): "Re: Monthly activity report"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
