ASP/PHP? sorry cant help you but asp syntax is almost same with vba... try to explore the MsAccess queries and see the SQL View... Im sure it will give you some good hint there...
hth -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Rick Justis Sent: Wednesday, October 11, 2006 6:27 PM To: [email protected] Subject: RE: [ms_access] OT: creating a sql statement This is a web application that is pulling data from an access database. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of George Oro Sent: Wednesday, October 11, 2006 1:21 AM To: [email protected] Subject: RE: [ms_access] OT: creating a sql statement where and how you want to use the SQL Statement? pls explain more so we can give you exactly what you want, if we know ;D -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ]On Behalf Of Rick Justis Sent: Wednesday, October 11, 2006 8:12 AM To: [EMAIL PROTECTED] <mailto:coldfusion-howto%40yahoogroups.com> ; [email protected] <mailto:ms_access%40yahoogroups.com> ; [EMAIL PROTECTED] <mailto:SQL_beginners%40yahoogroups.com> Subject: [ms_access] OT: creating a sql statement I understand everyone here is really busy but I would appreciate any help on this that I could get. I am having trouble creating a sql statement. I have a table with several fields: field1, field2, field3,...,field10. the value of these fields is chosen via drop down with values from another table with field we'll call "drop". Now in that table each record has a category field. Now I need to create a sql query that will give me the records of the first table where the category of the value of field1-10 is of a certain value. I hope that makes sense and any help is appreciated. table1 ---------- field1 field2 field3 .... field10 table2 --------- drop category Questions?? Thanx... Rick [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ms_access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
