Creation Of A Query

  • Thread starter Thread starter James
  • Start date Start date
J

James

Hello...

Ok I have

1 table... Which has the following in:

Are you male or Female With a value list as an answer....

Then Q01 with a value list of true or false....
Then Q02 As above...
All the way through to Q25....

Now how do I create this query?? I have a text box which
is where I will have the total... Basically do I need to
create a query??? If so please could you assist me with
the createtion of that. I would like it to take the values
of the 3 combo boxes... and then look through the records
with that matching criteria and then give me the total
records it has found in the text box.

Does this help any?

Thanks

James
 
You'll probably need multiple queries, or some VBA to sort through the
logic.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
 
How do I achieve that then? I have been told to do
something like =forms!frmqry!cbo1

Then do something with teh criteria to make the query...
then make it into a totals query... but how do I make it
add up and create a percentage based on what I need?

Thanks

James
 
Back
Top