Search results for query: *

I am trying to create a bell curve graph in excel using the following fields: Site DSO DEC 2002 DEVIATION BAKER-NORTH SHORE 137 23 CAD 137 22 DERRICKip 121 6 DERRICKop 104 (11) DSLA...

I am trying to create a bell curve graph in excel using the following fields: Site DSO DEC 2002 DEVIATION BAKER-NORTH SHORE 137 23 CAD 137 22 DERRICKip 121 6 DERRICKop 104 (11) DSLA 158 43 GULFCOASTip 112 (3)...

When I try to drag the cell it doesn't change I can still only see half of the text. Half of the text is a blue color the rest is black.

I have text in a cell that I can see when I select the cell, however when I try to double click the cell so the text will auto fit it still only shows half of the text. Also when I print it only prints half of the text. Is there a way around this?

In excel I need to create a Macro that will look for a cell in column 5 that has the number 1 only in it next if that cell has number 1 I need to delete that row and the one above it.

I figured it out the cell that I was trying to link to was merged so the link was trying to pull from a range..... Thanks for you help skip.....

No, The cell I am referencing contains a number that is hand keyed. It's really wierd I can't figure out why it won't work!

If you go under edit/links down in the left hand corner should be a button labeled Startup Prompt. Click it and there should be the option to shut off the prompt and not update links. Hope that helps

I am trying to link two spreadsheets. I have both open and the fields in both are formatted to currency. When I enter the = and then click on the cell I want to link to and hit enter I get the #VALUE! error. I can't figure out what I am doing wrong..... can anyone help??

I am trying to create web based entry form. This is my first time doodling with the online capability with access. What is the quickest way to create an online data entry form? I have tried the wizard but it will only create a data access page.

Every month I import a file into excel and I set it up with auto filter. I would like to add a field that will only sum the fields filtered not every field in between. Basically as a person filters this field will automatically adgust to only sum the records showing. Can someone show me how to...

Yes sometimes the fields that will be added are null. I tried = NZ() but got the same results as before??? Is there any other suggestion???

I have a table with the following feilds NAME, COMPANY, CURRENT, MONTH1, MONTH2, MONTH3. I drug all of these fields down into the query and I want to add an expression field that adds MONTH1 and MONTH2 columns in the last field. In the expression builder I put: = [TblMainData]![MONTH 1] +...

I am trying to create an update query that will update Tbl B info with a field from Tbl A. Example: Tbl A contains the following fields: Site Batch# Date Tbl B contains the following fields: Site Date Batch Acct# I want to update the batch field in Tbl B with the batch number in Table...

I am trying to create an update query that will update Tbl B info with a field from Tbl A. Example: Tbl A contains the following fields: Site Batch# Date Tbl B contains the following fields: Site Date Batch Acct# I want to update the batch field in Tbl B with the batch number in Table...

I am trying to append a field in table A to a field in table B. Table B already has records in it however the first field is left blank. There are three fields in table A however I only want one of them to append to table B. Both table A and B contain two fields that have the same data, I only...

When I try to set up a specification I get an error box that states "Too few parameters expected"

I changed the ext to csv but when I open the file in note pad it isn't seperated by commas it appears to be seperated by tab..

Hello, I am trying to export a query as a text file which I have been able to do, however I am trying to export it as a comma delimited file and I can't find that option under the Macro. It lists text, excel, html, rich text and so on. Can someone help me with this????

Hello, I am trying to export a query as a text file which I have been able to do, however I am trying to export it as a comma delimited file and I can't find that option under the Macro. It lists text, excel, html, rich text and so on. Can someone help me with this????