Without more info, I would have thought that the where clause is back to front, i.e. where company.area = combo1.combo
If this is in a form then maybe it would be Me.combo1.combo Regards Pete --- In AccessDevelopers@yahoogroups.com, "budakdigital2003" <[EMAIL PROTECTED]> wrote: > > i working on a database that will sort the record by area and customer > but i'm can anyone tell how the sql query goes? > i mean like > > select * from company where combo1.combo = company.area > > is this correct? > > i try writing it in the query menu in the criteria but the sql code > won't work help please > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/q7folB/TM --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> 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/
