Dear george
Thanks in advance for your valuable contribution of your IT
knowledge through this group
I am not an expert in MSAcess. I will like to gather some information
about table relation ship, Are you have any reference for the table
relation ship.
Thanks & Regards,
Muhamed Faisal.
_____
From: Mohammed Faisal
Sent: December 27, 2006 2: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]
<mailto:george%40cnet2010.com> ]
Sent: December 27, 2006 2:21 PM
To: [email protected] <mailto:ms_access%40yahoogroups.com>
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: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:47 PM
To: [email protected] <mailto:ms_access%40yahoogroups.com>
<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>
<mailto:george%40cnet2010.com> ]
Sent: December 27, 2006 1:38 PM
To: [email protected] <mailto:ms_access%40yahoogroups.com>
<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:ms_access%40yahoogroups.com>
[mailto:[email protected] <mailto:ms_access%40yahoogroups.com>
<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>
<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]
[Non-text portions of this message have been removed]
