Hi,
I need to create a crosstab query using vba code. I have a table with six fields. I need to have two fields going vertical and one horizontal and another field summed is the data.
Im using Access 2000. A sample of the final outcome would look like the data below:
Year Month 210000...
Thanks KenWright for the response....can you give me an example of how u would use caveat in this situation. My excel help isnt too good. it doesnt have caveat in it.
Thanks,
mike
Hi,
I tried the pivot table the way you specified but it does not show up. my data actually has 170 columns and 145 rows. i just put a little sample on here.
So im just saying that i tried the pivot table and it did not work out for me. so if you or anyone has any other ideas about how i...
Thanks skip for the response. It was interesting to try it out using a pivot table, but what i was looking for and should have specified is that I need to do this with code.
Cuz i need to run it a lot of times. So if anyone can help me out with some code on how to convert the numbers into...
I have data like this below. I am using Excel 2000.
Year Month 210000 236000 237000
1990 1 2 341 188
1990 2 0 325 169
1990 3 1 343 174
1990 4 3 321 263
1990 5 1 354 305
1990 6 1 375...
Thanks PH for the response.
The code works for when no item is selected but it also displays the message box when an item is selected. If an item is selected then the message box should not display.
If you could think of some code that will make the message box only display if no items are...
Thanks DreamerZ for the response.
You are correct. The code that u wrote will display the message box if the list box is empty. That is one part that i needed, thanks.
But I also need the message box to display if the listbox is populated with the 11 items and if no items are selected...
Hi,
I have a command button(cmdDerive) and a list box(listbox2) in a Microsoft Excel form. The list box has 11 items in it. When i select an item in the list box and click on the command button a calculation takes place.
I need to add code so that if i do not have an item in the list box...
Hi,
thanks for the replies...there are about 111 different NAICS values. and the years go from 1990-2001. i would like to group by all the variables including naics. I would like the data to be arranged in a simlar way as it is now. but it does not have to be exactly the same. im not...
Hi,
I have data in excel 2000 and i need to get the average of the "Employ" field grouped by all the other fields. Here is an example of the data:
Year Month Owner NAICS Employ
1990 4 3 2210 44
1991 6 3 6111 2794
1994 7 5 6116 54
1993...
Hi. I'm trying to copy a pivot table into a new worksheet using chart.copy. That turns the data sources into value lists (so not linked back to the pivot table). That's what I want because I want a graph suitable for printing, without all of the pivot table buttons. The problem is that if I have...
I'm trying to make a list box in Excel that takes a value list from a semicolon deliminted string (ie, "how; now; brown; cow"). In Access, I'd just set the RowSourceType to "Value List" and then assign the string to RowSource, but there isn't any RowSourceType in Excel.
I...
Hi,
I need to add a field to an Access Database using VBA code.
Can this be done without using DAO. Because i am using a recordset in my code. or does that even matter. Im using Office 2000.
Thanks,
mike
Hi,
I have a data that consist of 5 fields and is as follows:
YRQTR County month1Emp month2Emp month3Emp
19901 031 5 7 6
19902 043 11 21 14
I need to put these five columns into four columns as follows...
Hi,
Can anyone tell me if it is possible to create three data series in with dual axes in one chart using excel. I have done it with two data series but i dont know if you can do it with three. I am using office 2000.
If someone can help me out I would appreciate it.
Thanks,
Mike
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.