Faisal, Check the relationship of the source of your queries.
hth, George -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Mohammed Faisal Sent: Wednesday, January 03, 2007 2:33 PM To: [email protected] Subject: RE: [ms_access] any tips on query pls On adding filed I am getting aerror message "too complex query" That is my actual problem Thanks & Regards, Muhamed Faisal. _____ From: Pearce, Norman [mailto:[EMAIL PROTECTED] Sent: January 03, 2007 12:45 PM To: [email protected] Subject: RE: [ms_access] any tips on query pls Muhammed, Sorry a bit late on this thread , been enjoying a few days off over the festive period. In query design view, just double click on the filed name in the source table/query. That will automatically add a new column. You can then drag the column headers to the required sequence. Regards Norman Pearce IM&T Learning Manager The Training Centre Ealing Hospital NHS Trust Developing the foundations for your success -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ] On Behalf Of Mohammed Faisal Sent: 26 December 2006 05:12 To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: [ms_access] any tips on query pls Dear Friends While making one query I can make a query only for 16 fields, actually I want to add more field (say 30 field) So any tips for increasing more fields in the query???????? Pls let me know Thanks & Regards, Muhamed Faisal. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
