By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 1,089 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Query syntax?

P: n/a
I need to execute a query that I'm not sure how to format in Access.

Table consists of these fields:
ClientID (may be repeated as several months are in the table, key =
Firstmonth Yes/No
Paid Yes/No
Balance $

I want a query that counts the clients who have paid their first 6 bills
(Paid = yes) and
their total balance as of last month which may any month after these 6 (e.g.
MM=12 if December) and that lives in NewYork in this last month.

BTW: Does Access 2003 supposedly have better speed than Access XP?

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Use SQL to do the work, or experiment with design view (Access has a
nice way to do things in design view).

Assuming your table name is "Clients"...

In SQL view:

SELECT Count(ClientID) AS ClientCount, City, Paid
FROM Clients
HAVING (((Clients.[City])="New York") AND ((Clients.[Paid])="Yes"));

Good luck!
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.