Search results for query: *

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 a lot guys. You both were very helpful.

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

I followed ur steps and then i click finish and the pivot table does not appear. All the column headings are unique. what do u suggest? 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, Is there a way to put minimize and maximize buttons on a userfrom in excel. I am using excel 2000. thanks, mike

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...

Disregard this question....problem solved... thanks

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

Thanks a lot Dkalel that's what I was looking for. 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