Re: Help with SQL statement
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 04/29/04
- Next message: William Morris: "Re: ASP Treeview SQL Server - URGENT NEED!"
- Previous message: Ray at <%=sLocation%> [MVP]: "Re: automatic emails"
- In reply to: Ben: "Re: Help with SQL statement"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 09:52:13 -0400
Ben wrote:
>> Database Type and Version
> Im Using Access 2000.
>
>> A few rows of relevant data inside of tblUsers
> ---------------------------
> ID |Gender |Base |Age |
> ---------------------------
>
> ID: autonumber (int)
> Gender: Male or Female (text)
> Base: list of the 13 bases (text)
> Age: Number between 9 and 18 (int)
>
Where are the rows of data?
Never mind, I think (hope) I have the idea.
You will need to combine the results of two queries:
To get the gender portion broken out, use the Access Crosstab Query Wizard
to generate the sql for you..
The age breakdown can be done by a grouping query.
Then join these two queries to get the final result.
Play around with it for awhile. If you get stuck, get back to us.
Bob Barrows
-- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
- Next message: William Morris: "Re: ASP Treeview SQL Server - URGENT NEED!"
- Previous message: Ray at <%=sLocation%> [MVP]: "Re: automatic emails"
- In reply to: Ben: "Re: Help with SQL statement"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
