Re: Filter by sum of counts

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Doesn't matter.

Your third query (in SQL view) should look something like:

PARAMETERS [Enter a starting date] DateTime;
SELECT * FROM qry2;

If you have more than one parameter, just separate them by commas. Do you
know how to define parameters in the query grid?

If not,
1. open the query in design mode.
2. right click in the grey area next to the box that displays qry2 and the
fields that are in it
3. Select Parameters from the popup menu
4. In the Parameter column, enter your parameter, exactly the way it used
in your query. In your case, it will look like:

[Enter a starting date]

5. In the DataType column, enter Date/Time

HTH
Dale


<runnik@xxxxxxxxx> wrote in message
news:6137c090-5d3d-4590-9499-a597c4b95dd6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I would, but the third query doesn't have the date field available to
it, since it's not a displayed field in the other two queries.

Jason


On Dec 6, 4:17 pm, Dale Fye <dale....@xxxxxxxxxx> wrote:
Add the same parameters clause that you have in the other query to the
beginning of the 3rd query.

HTH
Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.

"run...@xxxxxxxxx" wrote:
That's OK. Yes, his solution worked for me, but now I have another
question/problem. In my underlying table, I have a date field. I
figured out that by putting a parameter asking for a starting date and
ending date into the first two queries, that I can limit my results to
just the dates that are inputted by the user. However, when I try to
create a chart based on the third query, it states that the Microsoft
Jet database engine does not recognize '[Enter a starting date]' as a
valid field name or expression. I know this is because the third query
does not contain the parameter input, but I don't know how to get
around that. Any suggestions?

Jason

On Dec 6, 10:50 am, Dale Fye <dale....@xxxxxxxxxx> wrote:
I misinterpretted what you were looking for. The way I read your OP,
I had
the impression that you only wanted those vendors that had at least 5
records
(Options A, B, C, D, E, F, ...) in your query, not where the sum of
the
number in the right had column totaled 5 or more. I see that Johns
three
query solution worked for you.

Good Luck



.

Relevant Pages

  • Table with 3 queries
    ... I have to make a table with the information of three different queries. ... The first and second columns must be ... of the second query and the fourth with the result of the third query. ...
    (comp.lang.php)
  • Re: Filter by sum of counts
    ... I had no clue you could define parameters using the popup menu. ... Your third query should look something like: ... since it's not a displayed field in the other two queries. ...
    (microsoft.public.access.queries)
  • Re: Filter by sum of counts
    ... Please reply to newsgroup only. ... Your third query should look something like: ... since it's not a displayed field in the other two queries. ...
    (microsoft.public.access.queries)
  • Re: Query to Find Members of a Group at a Point in Time
    ... Is the third query a Union query? ... SELECT Group, membername, minas InDate ...
    (comp.databases.ms-access)
  • Re: Query to Find Members of a Group at a Point in Time
    ... Is the third query a Union query? ... The NZ is for when there is no out record for a particular member. ...
    (comp.databases.ms-access)