Simple query solution required 
Author Message
 Simple query solution required

I have a similar problem but i cannot get your example database or mine to
work using you solution.  Please help.

Mark Reavill    



Quote:
> Try this out:

> --
> Kipp Woodard (MS Access MVP, MCP)

> MESA Solutions -   http://www.*-*-*.com/
> 7800 Highway 20 West
> Tower Building, 4th floor
> Huntsville, AL 35807

> (205) 864-0400



Quote:
> >Hi everyone,

> >I would like to know if we could create a custom drop-down parameter for
a
> >query.
> >If we can, could you show me how using the SolutionNeeded.mdb file
> attached.

> >I have included 2 tables and a query in this Database.  The information
> >contained in
> >Cases Category Table should be used as a drop-down list parameter.  All
the
> >other
> >fields of the query is being derived from the other table, "tblAll New
ISD
> >Case Table".
> >The required fields in the query is in the query named, "qryBy Issues
> >Category".



Mon, 21 May 2001 03:00:00 GMT  
 Simple query solution required
Matthew-

You can't do a drop-down parameter directly in a query.  You need to build a
form with a combo box that displays the available categories.  Give the user
a command button to open the target query or a form bound to the query.  In
the query, you can refer to the combo box as a filter using an expression
like:

   Forms![My Parameter form]![My Option Combo]

.. where "My Parameter form" is the name of the form containing the paramter
combo box, and "My Option Combo" is the name of the combo on the form.

For your second problem, you need to start with a Crosstab query.  Make
User-ID the Row Heading, Count(*) as The Value, and Status as the Column
Heading.  Use this query as the source for a report to do additional
totalling.

HTH...
--
John Viescas
Access MVP
author, "Running Microsoft Access 97"
http://www.amazon.com/exec/obidos/ISBN=1572313234/

P.S.  Please DO NOT post binaries in this newsgroup -- only a complete idiot
would ever open such a binary file anyway.

Quote:

>Hi everyone,

>I would like to know if we could create a custom drop-down parameter for a
>query.
>If we can, could you show me how using the SolutionNeeded.mdb file
attached.

>I have included 2 tables and a query in this Database.  The information
>contained in
>Cases Category Table should be used as a drop-down list parameter.  All the
>other
>fields of the query is being derived from the other table, "tblAll New ISD
>Case Table".
>The required fields in the query is in the query named, "qryBy Issues
>Category".

>Another query, which I am having trouble building is,
>A query which would give me a summary report in a spreadsheet format, with
>rows and columns,

>The rows and columns should include,

>1.    the User-ID as the row using the "Assigned to" field,

>2.    "Count of Issues Not Closed" as the column, using the Status field,
>e.g. status of
>anything, such as, O, H, A.....etc except for ZC which is a closed status.

>3.    "# of Issues closed this week", as the column, using the Status field
>which has a
>value of "ZC"

>4.    "New Issues for this week", as the column, using "Submit date" field.

>I would really appreciate, if you could please guide me in the right
>direction for the above.
>Also, if you could cc: the reply to my University account,


>Thanks a million,

>Matt.



Mon, 21 May 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Probably a simple solution for this query problem

2. Complex query problem in need of simple solution

3. Query problem...probably simple solution...but I am new to this :)

4. Simple Question - Hopefull simple solution

5. Simple legend problem, is there a simple solution?

6. Help required with a Simple recordset query

7. Simple query builder control required

8. Simple query builder control required

9. Telephony Solution Required

10. solution required


 
Powered by phpBB® Forum Software © phpBB Group