Solved

How to make CrossTab Query a table

Posted on 2014-12-29
9
115 Views
Last Modified: 2015-01-05
How do you make CrossTab Query  a table
0
Comment
Question by:Jass Saini
  • 3
  • 2
  • 2
  • +2
9 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
0
 
LVL 30

Expert Comment

by:hnasr
Comment Utility
Do you mean reverting the cross tab to original table, or creating a make table query?
0
 
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
Comment Utility
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
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
oh maybe you mean this

Select CrosstabQuery .* Into NewTable
From CrosstabQuery
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
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
Comment Utility
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
Comment Utility
Hello Pat,

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

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
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
Comment Utility
Thanks Pat..I think my boss is agreeing to thing that cannot and should not be doen.
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

744 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now