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] Sent: December 27, 2006 1:38 PM To: [email protected] 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:[email protected] <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> 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]
