SQL Queries [ help ]

[Guest_imported]

ok im pretty new to VBA and ive been trying to do this for a while but i cant figure it out...

how can i carry out a query that checks to see if a variable [username] is the same as any of the usernames in a table [tblaccess] from a database [currentDb] ok any help is greatly appreciated...

 

[smedvid]

Sounds like a little duplicate check... I use DCount() for such things. htwh. Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/