Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements

3 Posted Topics

Member Avatar for elainenguyen

Hi, I am trying create a query that counts all records which have the field Hypotension=1 (which is Yes), but I only want to count the same customer once. For example: My table has 3 fields: RecID (primary key), MRN, and Hypotension RecID Cus# Hypotension 1 6 1 2 6 …

Member Avatar for timothybard
0
115
Member Avatar for elainenguyen

I am doing Acess database with VBA. I have 3 tables (you can look at the code below). The codes works when searching for records that are exist in the tables. But when I try a record that doesn't exist in the table, I din't get the warning message that …

0
84
Member Avatar for WesDolezal

HI wes, I have the same problem as you do. I can do it with one table, but i couldn't make it with 3 tables. I wonder if you have found a way.;) Elaine [quote=WesDolezal;69386]Here is my problem: I have a search form in the project I am currently working …

Member Avatar for elainenguyen
0
375

The End.