Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    Unanswered: Crosstab Query Question Date Conversion

    I'm pretty new to access so this is probably a simple format option that I haven't been able to find.

    I have a table that lists a number of markets and various order data they had within a given date range. I'm writing an crosstab query that I want to show the sum of each order for each market. Date completed is the row heading and the system name is the column heading. With it counting the number of jobs for each system on each date. I want to change the dates (currently in m/dd/yyyy format) to 'yyyy' format so that I can get the total for the entire year for each market. I can't find where I can group them by year.

    Thanks,

    Ron

  2. #2
    Join Date
    Mar 2006
    Posts
    2
    nevermind. I got my answer.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •