Re: Filter by sum of counts

Glad I could help

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

email address is invalid
Please reply to newsgroup only.



"runnik@xxxxxxxxx" wrote:

I had no clue you could define parameters using the popup menu. I
don't think I ever learned that in any class I ever took. But that
appears to have worked for me. Thanks for your help.

Jason


On Dec 6, 8:48 pm, "Dale Fye" <dale....@xxxxxxxxxx> wrote:
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

<run...@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

  • RE: LDAP query for xerox 3545 printer/scanner blocked by SBS 2003?
    ... I am able to query the LDAP successfully from the second workstation but not ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Step2:Please ensure the DNS on workstation is pointed to SBS server. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Query Invalid operation
    ... > removed though they query is than able to output something. ... > Both tables are made up of values from an oracle database and are ... The tables from which these queries are extracting data, ... You've posted this message in the "modulesdaovba" newsgroup. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query Error 3073
    ... this newsgroup is about ADP and SQL-Server and has nothing to do with ... Try also to rebuild this query in a blank new MDB ... Taking a look with the SQL-Server Profiler could also give you some hints on ... I created a macro that runs 6 queries, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: need help designin a report
    ... There will be a query on the child table that does the same. ... Design the form that will become your subform to properly display the things ... subform to the proper place on your main form. ... >> I suggested in the earlier thread in this newsgroup (the subject was ...
    (microsoft.public.access.gettingstarted)
  • Re: Cant update table data from form
    ... > tables (the form is built on tables, not queries). ... to more than one newsgroup, ... If the record source of the form is a table (not a multi-table query) ...
    (microsoft.public.access.forms)