Hi

Is it possible to create a recordset from 2 tables?
I need to create a recordset from records that have a matching field value in 2 tables if you follow, some thing like this
<b>SELECT *
FROM Messages
WHERE Messages.YourEMailAddress = accessgroups.fldEmailaddress AND (Messages.Username = 'Admin' OR Messages.Username = 'Admin1')</b>

That obviously doesn't work or I wouldn't be asking.<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Hi, me again

Think I've got it now

<b>SELECT *
FROM Messages , accessgroups
WHERE Messages.YourEMailAddress = accessgroups.fldEmailaddress AND (Messages.Username = 'admin' OR Messages.Username = 'admin1')</b>

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome