Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Very embarassing - Access query
Message
 
 
To
01/11/2005 16:14:44
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01063741
Message ID:
01064211
Views:
19
>If you want just these patients with 2 visits change
>having count(VISITS.visit_date)> 1 to
>having count(VISITS.visit_date)= 2
>
>else you'll get all that have 3,4 or more visits.

I meant more than 1. 2 or more is fine. That's a minor point anyway <g>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform