crosstab

Hi All- I've searched the web but surprisingly can't come up with an answer for this simple question: Does Access 2010 have a limit on the number of column headers in crosstab queries? If so, what is it? I know that Access 2007 is limited to 255. I need to run multiple crosstabs with ~700...

Hi Guys, I've tried looking for this, but I am totally stumped! I have a select query with criteria in it, joining many tables together (generating a value of low, medium, high for my transactions), then I created a union table stacking columns A and B values together. All is fine in the union...

Hi, I'm using Microsoft Access 2010, but editing a Access 2000 database. I'm using a form with drop downs to filter the results of a query. HOWEVER, the form filter only works if I the query is anything but a Crosstab query. I really need this query to be in Crosstab form, but whenever I...

Hi All, I have a dataset of service orders (SO) - the pertinent fields are OpenDate, ClosedDate. I am trying to do essentially a crosstab type of result that would count "carryover" records in each month that it was a carryover. **Carryover service orders are defined as not closed in the...

Hi, I have a data set data shown below in Table 1 (this is just a sample data set, actual data set has 10,000 lines). I need to convert this to the format in Table 2. I figured the best way is to create a query based on Table 1 to get the "subject" hook and then to relate this subject query to...

I desperately need help with query design and any pointers would be greatly appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I currently have multiple monthly databases storing YTD medical expense data – expenditure by purchaser...

I need to build an Access 2007 report for comparing property sales. The field names are PropertyName, CityName, Community,SqFt, LotSize, Age, DateSold, Price. The report will need to be a side by side comparison where the user selects the properties to be compared and the report will have the...

All, Access 2007 SP2 Using a make table query based on a cross tab query to create/populate a table. The cross tab is based on a couple of other select queries which use form references to get parameter information. The cross tab itself with defined parameters works. The added dynamic...

I have a crosstab query that totals data by month. I also need it to sum that data for each employee. example: (this is what I have currently) Employee--jan--feb--mar--total Jack-------2----3----4----9 Jill---------1----2----5----8 Hill---------5----2----4----11 I need...

Hello, I am trying to build a report that will display a crosstab query. My query is prompting for a date range and running a count of the number of applications recd on those dates. When I veiw the query everything shows up correctly. Now I would like to display this query on a report...