Printing crosstab query
in [Queries]
|
Prev: #Num! in Link File
Next: Min Funtion
From: Afsaneh on 24 Apr 2010 00:29 Dear All, I would like to print a cross tab query directly.I need to change the date and title of it.but don't know How.since my cross tab query is not monthly and my columns are changing,I can't make a report out of it, that's why I wanna print it directly. tnx for your advice in advance.
From: Duane Hookom on 24 Apr 2010 16:29 There is a crosstab report solution at http://www.rogersaccesslibrary.com/forum/cross-tab_topic11&SID=deee386c-4bcz-c5bdz732-37361f36-2abf9742.html. If we knew more about your crosstab, we might be able to provide a better solution. -- Duane Hookom MS Access MVP "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message news:C7E4D749-FD50-4867-9640-2FCE2D6231FD(a)microsoft.com... > Dear All, > I would like to print a cross tab query directly.I need to change the date > and title of it.but don't know How.since my cross tab query is not > monthly > and my columns are changing,I can't make a report out of it, that's why I > wanna print it directly. tnx for your advice in advance.
From: Afsaneh on 28 Apr 2010 00:49 Dear duane, I need customer names as columns and statistics of products as rows.I managed to customize Your instance and use it. I really enjoyed undrestanding and customizung your report especially your LEVEL trick. It wasn't confusing at all.TNX a million. I just have the problem of filtering my xtab query. first, when using parameters access warns that it doesnt recognize my parameters as valid field names or expressions. and on a parametered report from a crosstab query ,access asks for each parameter twice . again tnx for your guidance. "Duane Hookom" wrote: > There is a crosstab report solution at > http://www.rogersaccesslibrary.com/forum/cross-tab_topic11&SID=deee386c-4bcz-c5bdz732-37361f36-2abf9742.html. > If we knew more about your crosstab, we might be able to provide a better > solution. > > > -- > Duane Hookom > MS Access MVP > > > "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message > news:C7E4D749-FD50-4867-9640-2FCE2D6231FD(a)microsoft.com... > > Dear All, > > I would like to print a cross tab query directly.I need to change the date > > and title of it.but don't know How.since my cross tab query is not > > monthly > > and my columns are changing,I can't make a report out of it, that's why I > > wanna print it directly. tnx for your advice in advance. >
From: Duane Hookom on 28 Apr 2010 21:42 IMO, parameters should never be prompts. All user interaction should be through controls on forms. Crosstab queries generally require you to set the parameter data types in the query. -- Duane Hookom MS Access MVP "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message news:56448730-658A-433A-B09C-7E936DBE7CB5(a)microsoft.com... > Dear duane, > I need customer names as columns and statistics of products as rows.I > managed to customize Your instance and use it. I really enjoyed > undrestanding > and customizung your report especially your LEVEL trick. It wasn't > confusing > at all.TNX a million. > I just have the problem of filtering my xtab query. first, when using > parameters access warns that it doesnt recognize my parameters as valid > field > names or expressions. and on a parametered report from a crosstab query > ,access asks for each parameter twice . again tnx for your guidance. > > "Duane Hookom" wrote: > >> There is a crosstab report solution at >> http://www.rogersaccesslibrary.com/forum/cross-tab_topic11&SID=deee386c-4bcz-c5bdz732-37361f36-2abf9742.html. >> If we knew more about your crosstab, we might be able to provide a better >> solution. >> >> >> -- >> Duane Hookom >> MS Access MVP >> >> >> "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message >> news:C7E4D749-FD50-4867-9640-2FCE2D6231FD(a)microsoft.com... >> > Dear All, >> > I would like to print a cross tab query directly.I need to change the >> > date >> > and title of it.but don't know How.since my cross tab query is not >> > monthly >> > and my columns are changing,I can't make a report out of it, that's why >> > I >> > wanna print it directly. tnx for your advice in advance. >>
From: Afsaneh on 3 May 2010 23:47
my xtab query is based on another select query, and the field I wanna filter is not on the xtab one, and when I try to filter the source one using a form to get the parameters ,I get the message from access "the microsoft jet database engine does not recognize '[Forms]![StaRep]![txtSal]' as a valid field name or exp"! here are my sql : "SELECT QfullStationary.*, Left$(QfullStationary!EnterDate,4) AS sal, Mid$(QfullStationary!EnterDate,5,2) AS mah, QfullStationary.OmorAlias, QfullStationary.LEVEL, Forms!StaRep!txtSal AS Expr1 FROM QfullStationary WHERE (((Left$([QfullStationary]![EnterDate],4))=[Forms]![StaRep]![txtSal]));" and TRANSFORM Sum(QStaMahSal.Qtty) AS SumOfQtty SELECT QStaMahSal.QfullStationary.LEVEL, QStaMahSal.NameGroup, QStaMahSal.NameKala, QStaMahSal.Moavenat, QStaMahSal.MoavenatId, Sum(QStaMahSal.Qtty) AS [جمع تعداد] FROM QStaMahSal GROUP BY QStaMahSal.QfullStationary.LEVEL, QStaMahSal.NameGroup, QStaMahSal.NameKala, QStaMahSal.Moavenat, QStaMahSal.MoavenatId PIVOT QStaMahSal.QfullStationary.OmorAlias; I just open my report from the form.tnx "Duane Hookom" wrote: > IMO, parameters should never be prompts. All user interaction should be > through controls on forms. Crosstab queries generally require you to set the > parameter data types in the query. > > -- > Duane Hookom > MS Access MVP > > > "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message > news:56448730-658A-433A-B09C-7E936DBE7CB5(a)microsoft.com... > > Dear duane, > > I need customer names as columns and statistics of products as rows.I > > managed to customize Your instance and use it. I really enjoyed > > undrestanding > > and customizung your report especially your LEVEL trick. It wasn't > > confusing > > at all.TNX a million. > > I just have the problem of filtering my xtab query. first, when using > > parameters access warns that it doesnt recognize my parameters as valid > > field > > names or expressions. and on a parametered report from a crosstab query > > ,access asks for each parameter twice . again tnx for your guidance. > > > > "Duane Hookom" wrote: > > > >> There is a crosstab report solution at > >> http://www.rogersaccesslibrary.com/forum/cross-tab_topic11&SID=deee386c-4bcz-c5bdz732-37361f36-2abf9742.html. > >> If we knew more about your crosstab, we might be able to provide a better > >> solution. > >> > >> > >> -- > >> Duane Hookom > >> MS Access MVP > >> > >> > >> "Afsaneh" <Afsaneh(a)discussions.microsoft.com> wrote in message > >> news:C7E4D749-FD50-4867-9640-2FCE2D6231FD(a)microsoft.com... > >> > Dear All, > >> > I would like to print a cross tab query directly.I need to change the > >> > date > >> > and title of it.but don't know How.since my cross tab query is not > >> > monthly > >> > and my columns are changing,I can't make a report out of it, that's why > >> > I > >> > wanna print it directly. tnx for your advice in advance. > >> |