X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Change Format Of Data., Access 2007    
post Feb 14 2018, 02:08 PM

Posts: 37
Joined: 14-February 18

Hi, Is there a query that could change from this format ?

Account# Account Description Store# Year Sum Of Amount
701900 Miscellaneous Expense                  00706  2015 20
701900 Miscellaneous Expense                  00706  2016 25
701900 Miscellaneous Expense                      00706  2017 35

to this one:

Account# Account Description Store# 2015 2016 2017
701900 Miscellanous Expense 00706 20 25 35


Go to the top of the page
post Feb 14 2018, 02:10 PM

Access Wiki and Forums Moderator
Posts: 72,985
Joined: 19-June 07
From: SunnySandyEggo


I think so... Try using a Crosstab query.

Hope it helps...

Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
post Feb 14 2018, 02:11 PM

UtterAccess VIP
Posts: 8,660
Joined: 25-October 10
From: Gulf South USA


Looks like you could use a Crosstab query to do that. The Crosstab Wizard should walk you through setting this up, although you might have to tweak the SQL.


Looks like theDBguy has faster fingers today (okay, as usual!).

"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    21st August 2018 - 06:11 PM