Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to access. I have a linked table that I'm using to query ODBC
database. For that reason, I cannot adjust my table, right?

I have a query that shows our order position over a two year period. There
is a date field to query on. I'd like to be able to view the fiscal years in
comparison. When I use the pivot table function, I'm able to separate the
detail by months, or calendar years, but am looking for a way to identify my
fiscal year so that the detail will be comparative.

Can anyone help me? Is there a way in the pivot table to do this?

Or, Is there a way in the query to use a calculated field to say,
IIf([date_field] between 07/01/2004 and 06/30/2004, "2005","2004")

Please check my if my syntax is appropriate.

Thank you.
 
Can anyone help me? Is there a way in the pivot table to do this?

Or, Is there a way in the query to use a calculated field to say,
IIf([date_field] between 07/01/2004 and 06/30/2004, "2005","2004")
Click to expand...

A simpler way to get the fiscal year, if the fiscal year starts July
1, would be

Year(DateAdd("m", 6, [date_field]))


John W. Vinson[MVP]
 
Thank you. Your response solved my problem and give us a valuable business
tool to use. Many thanks.

John Vinson said:
Can anyone help me? Is there a way in the pivot table to do this?

Or, Is there a way in the query to use a calculated field to say,
IIf([date_field] between 07/01/2004 and 06/30/2004, "2005","2004")
Click to expand...

A simpler way to get the fiscal year, if the fiscal year starts July
1, would be

Year(DateAdd("m", 6, [date_field]))


John W. Vinson[MVP]
Click to expand...
 
Back
Top