473,320 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Access having row like excel

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
6 1620
Design a Report to display in this format based on the Query; alternatively just export the data to Excel!! ;-)
Feb 11 '07 #2
NeoPa
32,556 Expert Mod 16PB
If you post your table MetaData and some example data then we can probably help.
Feb 11 '07 #3
nico5038
3,080 Expert 2GB
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
32,556 Expert Mod 16PB
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
kaykae
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
kaykae
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

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

Similar topics

3
by: juffles | last post by:
Dear Anyone, I am a newbie so please forgive my ignorance. Is there anyway that i can migrate data from access to excel and for the data to be presented as a graph all in one single button? ...
5
by: Tammy | last post by:
I am doing some genealogy research and I have discovered that there is a lot of data available on the web in text format. The problem is that the columns in the files are lined up by spaces. I'd...
3
by: info | last post by:
After using clipboard functions in Excel controlled from Access VBA, Excel doesn't quit when I use the following ExcelApp.Quit Set ExcelApp = Nothing If I don't use the clipboard functions in...
12
by: D. Shane Fowlkes | last post by:
This most likely belongs in another forum but I thought I'd start here. I have a COM Object written in VB6. The DLL will access MS Excel and use it's Object Library to write a customized report...
13
by: nuti | last post by:
Hi all, I am fairly new to VB.I am trying to figure out as how to write a script so that i can read the data from an excel sheet to Access. can u guys please help me out? cheers, nuti
1
by: garry.oxnard | last post by:
Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...
3
by: aniphilip | last post by:
Hi All, I have a requirement to automate Access functionality from Excel. I need to open Access, trigger button events and close Access from Excel. I Achieved opening Access from Excel. I...
4
by: torontolancer | last post by:
Hi there how r u .I would really appriciate ur concern regarding checking out this code. its beind a command button and i am have a combo box selecing a query criteria and then pressing the button...
3
by: peteh | last post by:
Hi All; I have tried to find this info on the IBM site, but alas... We are running DB2 v9.1.1 and making extensive use of Information Integrator (now known as Websphere Federation Server?!) to...
0
by: Simon | last post by:
Dear reader, How to export a hyperlink field from Access to Excel, so it is also working in Excel. In Excel you have for the Hyperlink to parts: a.. Text To Display
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.