Re: [MS_AccessPros] Crosstab Query

 

Youssef-

When you put a Parameter in a query, you should always explicitly declare it with a PARAMETERS clause, but for most queries Access lets you get away without it.  In a Crosstab query, you *must* explicitly declare the parameter for it to work.

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 

http://www.viescas.com/ 

(Paris, France)

On Aug 26, 2014, at 10:30 AM, youssef2309@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

I need to filter data from a big list and then use the result to build a crosstab query

is it possible as it seems that the crosstab query does not accept the criteria

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 (6)

Visit Your Group

• New Members 1
• New Links 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___