473,240 Members | 1,719 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,240 software developers and data experts.

Create a table from a crosstab query

I have a crosstab query which gathers data from a regular table and creates columns for the months in the year with volume for each month. I want to be able export/send the data to a brand new table, which would keep the new formating with the months as fields.

So basicall i want to create a table from that crosstab query that looks identical to the query. I tried using a make-table query but this just puts all the data back into the way the original table was, without column fields for the months.
Oct 31 '07 #1
4 36096
nico5038
3,080 Expert 2GB
Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)
Oct 31 '07 #2
im dj
1
Use the save crosstable query as the input for your Make-table query.
(Second tab when defining a new query holds the queries you can use)

Nic;o)

im a newbie on doing cross-tabs and make-tables...how do I do this?

Thanks!
Jul 25 '08 #3
Maybe the previous instructions were a bit unclear.

You have a crosstab you like. Don't try to change that crosstab to a make-table, because then it won't pivot any more. Instead, save that crosstab. Now create a separate make table query. Use the crosstab as the input to this second query, and simply select all fields from the crosstab. Now, when you run this make table query, it'll run the crosstab query, then make a table based on the results.

does that make sense now?
May 12 '09 #4
Does for me. Thanks rwickberg!
Jun 19 '12 #5

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

Similar topics

2
by: Claus Haslauer | last post by:
Hi, I want to create a crosstab query that looks like this Date | Elevation 1 | Elevation 2 | ... ______________________________________________________________________ Date 1 | xx.y | xx.y...
1
by: Philehof | last post by:
Hi Group. I would like to add some information to a query. I tried to create a table with the information from the query but then if i run the query again the additional data will be lost. ...
2
by: jason.teen | last post by:
Hi All, I am having trouble creating a crosstab query. In my original data I have two columns, One called "Categorized" and one called "Mapped' in which those columns can hold values of "true"...
3
by: Mike | last post by:
Hi, Im trying to create a crosstab query with fewer than 255 headings (about 50), but it crashes when I try to save after writing the heading names in the query property "column headings". My...
2
by: Mike | last post by:
Hi everyone, I found the Access reports too limited to do what i wanted so i created a module to export a crosstab query to an excel file, and then i modify it as i want. My problem is that i...
1
by: rdeanstew | last post by:
I have created a query and saved it. The Access 2003 allowed me to create a table using the query. To the life of me I can't find out where to do this in A2007. Can someone either answer this or...
0
by: carl_birchall | last post by:
I would really appreciate a nudge in the right direction on how to resolve this issue, as despite checking previous listings still not getting anywhere. I have 4 tables tblApplicant_Person...
2
by: Jim Devenish | last post by:
I wish to create a crosstab query as the record source for a report. It needs to count data between selected dates which are entered by the user in a popup window. The following Select query...
1
by: TZEM | last post by:
Hi - I'm new to Access and trying to create a complicated database that records info about system interfaces. I want to create a crosstab query that returns a field from the interface record, if a...
4
by: tetsuo2030 | last post by:
Hi all, What I'm trying to do is create a crosstab query (based on a temp table) in VBA, then export it to Excel. The temp table is built off a form where the user enters a parameter(s) in a...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
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: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
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...

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.