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
<*> 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/