By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Access having row like excel

P: 14
Automotive System 6 0 0 0
Available Resource 6 6 6 6
Resource Requirement 2 3 9
Delta 5 4 3 (3)
Delta in hrs 114 64 (107)
OT hrs on weekdays 60 48 36 60
OT hrs on Sat 43 43 43 43
OT hrs on Sun 43 43 43 43
Delta in hrs after OT 323 247 185 38


Can I have Access providing my results this way instead of in column format?
I have it all in a query in columns but I'd like to get it to be this way instead.

Thanks so much in advance if it is possible!!!!!
Feb 10 '07 #1
Share this Question
Share on Google+
6 Replies


P: 9
Design a Report to display in this format based on the Query; alternatively just export the data to Excel!! ;-)
Feb 11 '07 #2

NeoPa
Expert Mod 15k+
P: 31,492
If you post your table MetaData and some example data then we can probably help.
Feb 11 '07 #3

nico5038
Expert 2.5K+
P: 3,072
I would use a table with fields like:
ID (Autonumber)
Description (Text)
Sequence (Number)
Value (Number/text?)

This requires to enter the data like:
Available Resource 1 6
Available Resource 2 6
Available Resource 3 6
Available Resource 4 6
Resource Requirement 1 6
Resource Requirement 2 0
Resource Requirement 3 0
Resource Requirement 4 0
etc.

Now you can use a crosstable query to get the Value data in 4 columns behind the Description.

Getting the idea ?

Nic;o)
Feb 11 '07 #4

NeoPa
Expert Mod 15k+
P: 31,492
Automotive System 6 0 0 0
Available Resource 6 6 6 6
Resource Requirement 2 3 9
Delta 5 4 3 (3)
Delta in hrs 114 64 (107)
OT hrs on weekdays 60 48 36 60
OT hrs on Sat 43 43 43 43
OT hrs on Sun 43 43 43 43
Delta in hrs after OT 323 247 185 38


Can I have Access providing my results this way instead of in column format?
I have it all in a query in columns but I'd like to get it to be this way instead.

Thanks so much in advance if it is possible!!!!!
You could also look in here (Combining Multiple Rows of one Field into One Result) if you want the results to be merged into a list in a single column. This is better for situations where there are unpredictable numbers of rows (records) per main item.
Feb 11 '07 #5

P: 14
I don't know how to put my data into proper alignment for you guys to see.....


The numbers all are based on week 1,2,3,n so forth (column field on top of them)

And then we have all these different rows that are calculated fields actually.

So far, I've tried to use the crosstab but I can only use it for 1 row headin 1 column heading and 1 value......... And the row heading doesn't provide the title of the rows...............does that make sense?
Feb 12 '07 #6

P: 14
Planned Week SumOfModelQuantity TotalHCReq Available Resource Delta DeltaHrs OTonWkdays DeltaHrsAftOT
TBA 8 0 6 6 0 0 86
Wk1 28 3 6 3 64 36 186
Wk2 47 9 6 -3 -107 60 39
Wk3 54 10 6 -4 -142 60 4
Wk4 26 8 6 -2 -71 60 75
Wk49 2 1 6 5 178 60 324
Wk5 4 3 6 3 85 48 219
Wk52 0 0 6 6 171 48 305
Wk8 1 1 6 5 107 36 229
Grand Total



I can have it this way in the pivot table............but I'd like the planned week to be at the top and the other fields to the left like in my 1st post.......So sorry for the messyness......I can't seem to align the numbers properly to show.
Feb 12 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.