Re: Can't figure out how to write this CrosTab properly - Field heading problem

sara <saraqpost@xxxxxxxxx> wrote in
news:99f10e56-13b5-4194-b131-a68e3ec68dde@xxxxxxxxxxxxxxxxxxxxxxxxxxx
m:

On Oct 26, 7:00 am, sara <saraqp...@xxxxxxxxx> wrote:
On Oct 26, 12:44 am, Marshall Barton <marshbar...@xxxxxxxxxx>
wrote:





sara wrote:

[]

I tried this and I'm still not getting the "right" order; I
think it's when I switch years.
[]
I expect to see 12, 11, 10, 9 8, 7, 6, 5, 4, 3, 2, 1 (I put 12
- instead of 13 -  I have to work that one out myself for a
bit to figure out which number is right!)

But I'm seeing: 9, 8, 7, 6, 5, 4, 3,2, 12, 11, 10,1

Try it without using the Format function.  Format always
results in a text string, which sort the way you are seeing.

--
Marsh

Thank you, Marsh.  This does give me the numbers in the proper
sequence, but I don't know which month the numbers represent!  I
don't know how to get that.  I've tried tackingthe FiscalYear and
Month at the end of the above (without the format), but it
doesn't . Then it occurred to me to use the "DateSerial" that Bob
formulated for me - use that as the column heading and I think
that may work!

At least gives me the next step.  I have a date  - the first of
the month.  I just have to figure out how to turn that into YYMM
(Fiscal yr and Mo) in the report....which I should be able to do
with a format statement (I'm hoping) OR do it in the final query
I write for the report.

Do you think that will work?  I will try this approach later this
morning.
Many thanks - I'm getting there!
sara- Hide quoted text -

- Show quoted text -

I've tried all I can think of and I'm nowhere. I need the user to
enter FY and Fiscal Month (each chosen from combo boxes on the
form) and show the prior 12 months' data, with the proper
heading, on the report. Lost!

Thanks
Sara


You do not want to use e.g. 2009-10 as a column header in the query
feeding the report, because next month you will have a new column to
add and an old column to delete and the other columns will all need
to be moved. .

The query takes the data from the form to generate numbers from 1 to
12. (or 0 to 11)... That same form data can be used in the report to
calculate the headers for the report. The textboxes get their data
from the fields named 1 to 12.


--
Bob Quintal

PA is y I've altered my email address.
.

Relevant Pages

  • Re: Dates not sorting correctly in Report
    ... the report) from the query and the SQL is as follows: ... I have also tried deleting the inner joined query qryPumpsRunningBin, ... FiscalYear - Ascending with a group Header and Footer ... have removed ALL sorting from the query. ...
    (microsoft.public.access.reports)
  • Re: Dates not sorting correctly in Report
    ... I tried wrapping the field FiscalYear in Valin both the report fields ... the report) from the query and the SQL is as follows: ... FiscalYear - Ascending with a group Header and Footer ... have removed ALL sorting from the query. ...
    (microsoft.public.access.reports)
  • Re: Dates not sorting correctly in Report
    ... I tried wrapping the field FiscalYear in Valin both the report fields ... the report) from the query and the SQL is as follows: ... FiscalYear - Ascending with a group Header and Footer ... have removed ALL sorting from the query. ...
    (microsoft.public.access.reports)
  • Re: Cant figure out how to write this CrosTab properly - Field heading problem
    ... the query looks like this ... I've tried tackingthe FiscalYear and ... I write for the report. ... You do not want to use e.g. 2009-10 as a column header in the query ...
    (comp.databases.ms-access)
  • Re: Function In Column Header
    ... Private Sub Report_Open ... I would like to put a function in the column header of a query. ... This query will feed a report so maybe it's easier just ...
    (microsoft.public.access.queries)