I think it sounds like a UNION query. something like.... SELECT ErrorBy1, [field2], [field3]... FROM Table1 UNION SELECT ErrorBy2, [field2], [field3]... FROM Table1 You need to know that a UNION query cannot be displayed in "Design" view of the Query. You must use SQL view. Good Luck! Pete Bradshaw 860.226.3019
mailto:[EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Linda Moon Sent: Monday, October 09, 2006 4:39 PM To: [email protected] Subject: [ms_access] Re: Combining 2 fields in a query Sorry George. I wasn't clear with my question. The table keeps track of errors made. Sometimes two people are responsible for the error, thus "ErrorBy1" and "ErrorBy2". I want to create a report that shows who is making the errors, so I want to show the table w/ one person on each line, not two in the same line. They should show all the other info in the table. Thanks again for your help. Linda --- In [email protected] <mailto:ms_access%40yahoogroups.com> , "George Oro" <[EMAIL PROTECTED]> wrote: > > Type this in the column: > > ErrorBy:[ErrorBy1]&" "&[ErrorBy2] > > &" "& space > > > > > -----Original Message----- > From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ]On > Behalf Of Linda Moon > Sent: Friday, October 06, 2006 10:36 PM > To: [email protected] <mailto:ms_access%40yahoogroups.com> > Subject: [ms_access] Combining 2 fields in a query > > > I have a table with the fields "ErrorBy1" and "ErrorBy2". I want to > combine them in a query for a report. Can you tell me how to do that, > please? > > Thanks in advance for your response. > > Linda > > > > > > > Yahoo! Groups Links > ------------------------------------------------------------------------------ CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright 2006 CIGNA ============================================================================== [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/
