Search results

Hi gemmathe-husky When I had set the database, I had a field that I called part number, and set it to number type. The part number would look like something like this: 2354 Sinks The problem comes when I am trying to import access to excel so that I can use the pivottable. When it get...

So you are saying that once the table is imported to Excel, I can change the number field to a text field without losing the data? Thank you by the way for responding. Tony

Not sure what to do. I am able to go to excel and do an import of the database from access. So everything loads in find to excel, and can do pivottable. But what I am noticing is that where there should be text, there are numbers instead. If I just go say to access and do an export to...

Scrap is plastic defects. There are many, and I need to add more to the list. But if I do I lose the data that was already entered.

Hi MarkK So there is no way to add another field for scrap, and then in my total column add that scrap in the formula?

Hello Everyone, I wanted to add more items to my scrap form, which was not an issue. But where I have a field that it takes all of the scrap and adds them up did. I added the new items in the formula to add, which it worked, but it deleted everything that was entered in before that...

Hey, Ranman256 I tried to play with the pivotTable in access and it wants to do the same. It converts it to a number. Tony

Hi again Ranman256 I was going to excel and doing an import from access. The reason was because I wanted to use more than one table, and to make it automatically update. This way I would have the people receive the excel and not tamper with the access database. Is there a way to create...

Hello everyone. Has anyone worked with PivotTables. I am in excel and importing the database tables that I need for my PivotTables. Everything now is loading up great. What I am noticing is that where there would be text, it is showing me numbers. Example of a part number: 2427050-A RH Front...

Thank you for your help. I did have a #Num error and that is what was causing the problem. Thank you for your help. Tony

Thank you I got it to work. You all have been a great help. Tony

Thank you everyone, that did fix my error. I noticed that I had another one like that: [TotScrwBlank]/([TotScrwBlank]+[TotParts])*1000000 so would I rewrite that as: iff(([TotScrwBlank]+[TotParts])*1000000)=0,0, [TotScrwBlank]/([TotScrwBlank]+[TotParts])*1000000) Thank you...

Hi Ranman256 Thank you for responding. I tried what you said and I get the following: The expression you entered has a function containing the wrong number of arguments. I checked to make sure I entered it as you have it too. Tony.

I am getting a #Num! because sometimes there is no data to be entered. The formula I have does work, but what do I need to add to it so that it will produce a 0 value if no data is required. [TotScrwBlank]/[TotalAmount] Also, by adding anything to this formula, would this make me lose...

Hi RanMan256 Can you please walk me through this, not sure how to do that and could not find too much on this. And thank you very much for responding. Tony

Not sure where to post this. I am trying to import my tables from ms access 2010 to my ms excel 2010 and doing this from excel. I have already did three other tables and they went great. The last one everything looked good the first time and went in. Then when I went to run it again, I got...

Hello jdraw So would I use what you mentioned above in my query?

Hello, I really need help on this.

Hello, Can anyone help me on this issue.

Would you do something like this???? = Sum[Report] where x>0 Count([Report] where x>0 (IIf([rptEmployEvaluationOperator subreport].[Report].[HasData],[rptEmployEvaluationOperator subreport].[Report]![OPTotal],0)+IIf([rptEmployEvaluationOperatorTrainer...