[MS_AccessPros] Re: Crosstab Query

 

Youssef

Can you post the SQL for each query?

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---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: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___