PS. Just ring my bell after I send my previous mail. Are you familiar with Union Query, perhaps that will do the tricks.
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Mohammed Faisal Sent: Wednesday, December 27, 2006 3:39 PM To: [email protected] Subject: RE: [ms_access] error 3190 Dear George I need the entire field in that particular query that is why I use * Actually I want to make a report which should give details of three queries for that I try to make a single query by integrating the three queries. So what is next for making this complex query? There is any way to make a report which integrated with the at least three queries? Thanks & Regards, Muhamed Faisal. _____ From: George Oro [mailto:[EMAIL PROTECTED] Sent: December 27, 2006 2:21 PM To: [email protected] Subject: RE: [ms_access] error 3190 Hi Mohammed, Im a bit confused but what I understand is, the below is a complete separate query you used as a source: [PRESENTSTOCK Query] [UNIT PRICE Query] if you will include these in your column: [PRESENTSTOCK Query].* [UNIT PRICE Query].* ... meaning you are selecting all the fields from both queries. Then if both queries has to much fields or more than 255 if you will add it, then error will be raised (not so sure the column limitation) what you can do is, remove the above 2 columns then drag or select only the EXACT fields do you want. DONT, drag or select the * on the very first of your source because it will include all the fields from the query/table. HTH, George -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> ]On Behalf Of Mohammed Faisal Sent: Wednesday, December 27, 2006 2:47 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] error 3190 Dear George Pls see my sql code SELECT [PRESENTSTOCK Query].*, [UNIT PRICE Query].*, PRESENTSTOCKVALUETOTALALL.*, * FROM [PRESENTSTOCK Query], [UNIT PRICE Query], PRESENTSTOCKVALUETOTALALL; Hoping any solution from you Thanks & Regards, Muhamed Faisal. _____ From: George Oro [mailto:[EMAIL PROTECTED] <mailto:george%40cnet2010.com> ] Sent: December 27, 2006 1:38 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> Subject: RE: [ms_access] error 3190 Hi Muhamed, Hope you didn't use Select * from both 2 quiries, what I mean just use only the fields you want. Otherwise, paste your SQL Code so we can see it... HTH, George -----Original Message----- From: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> [mailto:[email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> ]On Behalf Of Mohammed Faisal Sent: Wednesday, December 27, 2006 2:15 PM To: [email protected] <mailto:ms_access%40yahoogroups.com> <mailto:ms_access%40yahoogroups.com> Subject: [ms_access] error 3190 Dears, While making a query (from another two query) I have received an error which is given below.Can any body have any idea about it. My a single query contain just 25 field only not 255 as mention in the error box Too many fields defined. (Error 3190) You tried to perform an operation that involves more than 255 fields. Reduce the number of fields, and then try the operation again. Thanks & Regards, Muhamed Faisal. [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links [Non-text portions of this message have been removed] Yahoo! Groups Links
