UtterAccess.com
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    
 
   
glenvin
post Feb 14 2018, 02:08 PM
Post#1



Posts: 1
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

Thanks,

Vince
Go to the top of the page
 
theDBguy
post Feb 14 2018, 02:10 PM
Post#2


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


Hi,

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
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
RJD
post Feb 14 2018, 02:11 PM
Post#3


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


welcome2UA.gif

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.

HTH
Joe

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 May 2018 - 12:22 AM