Youssef-
Whenever you have a Parameter in a query, it's always recommended that you explicitly declare the parameter and its data type using a PARAMETERS clause at the beginning of your SQL or by using Query / Parameters. When the query is a Crosstab, you MUST declare all parameters - both in the underlying queries and the Crosstab.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Oct 28, 2014, at 4:57 PM, wrmosca@comcast.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Youssef
---In MS_Access_Professionals@yahoogroups.com, <youssef2309@gmail.com> wrote :
Can you post the SQL for each query?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <youssef2309@gmail.com> wrote :
Dear All,
1- I have a big table contains details for BMW parts
2- I built 5 simple queries each one depend on the previous one
for exmple Qry_MstrLst_Step2 depend on Qry_MstrLst_Step1 and So on.
3- the last query should be Crosstab query, all data as a row heading except the "Model Name" should be Column heading and the quantity of each item under its model code
the problem is
the first 5 simple queries contains many criterias so the crosstab query makes an error
so, please support how to make the crosstab query accept the criterias in previous simple queries
thanks in advance
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar