access crosstab results?
[Users questions | Browse:63 | Favorites]
Users questions: TRANSFORMSum (foreign income reporting. [The amount of money income (the amount of discount U.S.)]) AS [income amount received (U.S. discount rate) of the total] SELECT foreign income reporting. [Recipient name], Sum (foreign income reporting. [Income The amount received (U.S. discount rate)]) AS [Total income amount received (the amount of discount U.S.)] FROM declare GROUPBY foreign income foreign income declaration. [Recipient name] PIVOTFormat ([reporting date], "mmm") In ("Jan", "February", " March, "" April "," May "," June "" July "" August "," September "," October "," November "" December "); above SQL, the results of total correct, but the date column results NULL, how to solve?
Experts answer: now understand what you mean, change this statement: SELECT involving Income to declare. [The payee name], Sum (foreign income reporting. [The amount of income section (off U.S. amount)]) AS [total income amount received (U.S. discount rate)] FROM declare GROUPBY foreign income foreign income declaration. [ Beneficiary Name] PIVOTmonthnam e (datepart ("m", foreign income reporting. [return date])) your original statement, format ([reporting date], "mmm") the result is a three letter acronym, of course, is not in the back in (. ...) inside, so the result is empty. When used, the most Good to sort the table first by reporting date. Monthname () and datepart () these two functions, I access2003 adopted.
Experts answer: now understand what you mean, change this statement: SELECT involving Income to declare. [The payee name], Sum (foreign income reporting. [The amount of income section (off U.S. amount)]) AS [total income amount received (U.S. discount rate)] FROM declare GROUPBY foreign income foreign income declaration. [ Beneficiary Name] PIVOTmonthnam e (datepart ("m", foreign income reporting. [return date])) your original statement, format ([reporting date], "mmm") the result is a three letter acronym, of course, is not in the back in (. ...) inside, so the result is empty. When used, the most Good to sort the table first by reporting date. Monthname () and datepart () these two functions, I access2003 adopted.
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.