?
Solved

How to make CrossTab Query a table

Posted on 2014-12-29
9
Medium Priority
?
125 Views
Last Modified: 2015-01-05
How do you make CrossTab Query  a table
0
Comment
Question by:Jass Saini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40522761
0
 
LVL 30

Expert Comment

by:hnasr
ID: 40522837
Do you mean reverting the cross tab to original table, or creating a make table query?
0
 
LVL 48

Expert Comment

by:Dale Fye
ID: 40522874
Take a look at my article on temp tables.temp tables.  You can simply pass that subroutine the name of your query and the name you want to give your new table.

UpdateTempTable "NewTableName", "CrossTabQuery"
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 40523030
oh maybe you mean this

Select CrosstabQuery .* Into NewTable
From CrosstabQuery
0
 
LVL 38

Expert Comment

by:PatHartman
ID: 40523824
Why are you making a temp table?  Why can't you use the crosstab directly as the RecordSource for the form/report/code?
0
 

Author Comment

by:Jass Saini
ID: 40525931
Hello Pat,

My boss keeps changing her mind.  My form was based off the orginal table.  I don't want to change my form..also how do you drop down options in a table or can you not?
0
 

Author Comment

by:Jass Saini
ID: 40528288
Hello Pat,

I am using a Crosstab query is that what you are asking
0
 
LVL 38

Accepted Solution

by:
PatHartman earned 2000 total points
ID: 40529837
You seem to have changed the question.  Crosstabs usually have variable columns but sometimes you can force them to be fixed.  For example, if you always want to show 12 months, you can add a ColumnHeadings property and that will fix the number of columns so even if you don't have data for March, March will still show up where it belongs.  

The second question sounds like you are asking about table level lookups and all I can say about that is DON'T DO IT!!!!!  It results in nothing but trouble once you move into queries and code.  They are only a crutch for people who don't know how to write queries.  Once you know how to write a query, you have no need for them.  All your maintenance is done via forms anyway and that is where you need the combo to be.  NOT in DS view of a table or query.
0
 

Author Closing Comment

by:Jass Saini
ID: 40531613
Thanks Pat..I think my boss is agreeing to thing that cannot and should not be doen.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question