By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,454 Members | 2,633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,454 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 =
clientID+Month)
Month MMYYYY
Firstmonth Yes/No
Paid Yes/No
City
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?

Anne
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.