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

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: 73,744
Joined: 19-June 07
From: SunnySandyEggo


Hi,

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

Hope it helps...
Go to the top of the page
 
RJD
post Feb 14 2018, 02:11 PM
Post#3


UtterAccess VIP
Posts: 9,184
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!).
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    17th November 2018 - 03:59 AM