Help me construct this count distinct query!

Hi guys,

I'm at my wits end, and just can't get what I want out of this query.

After some preparation, this is where I am at:

OBJ_CODE OBJ_MRC OBJ_CATEGORY SumOfREA_DIFF REA_DATES
2101 176 E40LF 3647.7 2005-10-28
2101 176 E40LF 245.9 2005-11-04
2101 176 E40LF 141 2005-11-10
2101 176 E40LF 85.1 2005-11-18


What I want to do in the end is have a count of all similar OBJ_CODE,
and for that count a sum of SumOfREA_DIFF, between two set dates. This
will be pushed back into excel where I will use a parameter query to
define the dates from a formula. So, assuming that the information I
want is between the dates of 2005-10-28 and 2005-11-18, what I would
like to see in the end would be:

OBJ_CODE OBJ_MRC OBJ_CATEGORY SumOfSumOfREA_DIFF
4 176 E40LF 4119.7

I'm hoping you can understand what I am trying to describe! Any
questions, feel free to email me direct at theseandavis@xxxxxxxxx, or
post to this thread. I will post back with the solution once it has
been figured out.

Thank you!

.

Relevant Pages

  • Re: wildcards in parameter queries dont work -access 2003
    ... "Tom Ellison" wrote: ... I have a query. ... I wanted to make a parameter query. ... I type the value, *John Smith*, to retrieve all the records. ...
    (microsoft.public.access.queries)
  • RE: Date Range on Report
    ... parameter query, putting the following in the Criteria row under the date ... two text boxes to the Report Header section, which I did, and set their ... "Owl Lover" wrote: ... I have created a Parameter query, which works, so I added two ...
    (microsoft.public.access.reports)
  • Re: Set a field before running query
    ... Access using the old DDE method, you can connect to a parameter query in ... DDE has some drawbacks (e.g. it hasn't really been supported for ... set up your query as a parameter query ... Word document, that's OK. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Parameter queries with mainform/subforms
    ... in other applications that I have developed. ... > I wouldn't use a Parameter Query for this. ... >> in the ER) that staff are assigned to each shift. ... >> parameter query that permits users to select a date range for both reports. ...
    (microsoft.public.access.queries)
  • Re: Exporting to a Text file
    ... >later Office or Windows service pack than the one in the ... >to avoid using a parameter query. ...
    (microsoft.public.access.externaldata)