crosstab query calculation YTD problem

[Lo031514]

Hi all,

I got below problem.. After I created a crosstab query pp, I could not create another query to calculate the YTD amount of ARPU. Does someone know what can I do? I confirm that my access has the right field for [pp].[Period]...

 

[Fazza]

the last bit of the WHERE clause isn't good. The bit that has ", Month(..) AS YTDAmount"

 

[Lo031514]

so Fazza what can i do？ I have no idea on it

 

[Fazza]

Delete it. The WHERE clause should only contain the criteria. Such as "WHERE onething > another AND this <> that"

The WHERE clause shown additionally wrongly has ", Month (...) AS Soemthing"
It has no place in the WHERE clause.

It may not be the only problem, btw. I think best to start a new thread giving sample of the source tables and a clear explanation of the relationship between the tables, and also show results wanted. regards

 

[Micron]

If you're going to alias a table, you must refer to the alias name afterwards, otherwise the original name can't be resolved. You give a table/domain an alias, then right away, re-alias it. I'd say that downstream, it makes no sense to Access.
e.g.
FROM pp As A INNER JOIN pp As OD ON A.Period = OD.Period

maybe
FROM pp As A INNER JOIN A ON OD.Period = A.Period

as long as OD is either the proper domain name, or if it is an alias, it must be aliased first, otherwise it will fail. Maybe that's not the real problem, or maybe it's one of several but I can't test it.

 

[xenou]

I got below problem.. After I created a crosstab query pp, I could not create another query to calculate the YTD amount of ARPU. Does someone know what can I do? I confirm that my access has the right field for [pp].[Period]...

I don't know why but I don't see your query. If you are still confused post the query text.