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

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

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

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

Hello all, I am trying to set up a macro that will close access if there is no activity after say 15 minutes.... Does anyone know how to do this??

I am trying to pull together data that has been summed from multiple tables. Example: Tbl1 has four fields: GROUP,DIVISION,PAYCODE,CURRENTMONTHTOTALS. Tble2 has four fields: GROUP,DIVISION,PAYCODE,MONTH1TOTALS. The only column that changes from table to table is the last field which is the sum...

I am trying to create a query that sums data greater than zero example: Blue cross month1 month2 month3 month4 -120.00 50.00 300.00 500.00 450.00 45.00 65.00 -45.00 78.00 -15.00 15.00 35.00 I only want to add values that...

I have a query that sums all of the credit card transaction totals. For example Visa 100.00, Mastercard 200.00 and American Express 190.00. The American express amount should only be 95.00 but it is showing 190.00 (double the amount). I checked the table to make sure that there were only two...

I have a query that sums all of the credit card transaction totals. For example Visa 100.00, Mastercard 200.00 and American Express 190.00. The American express amount should only be 95.00 but it is showing 190.00 (double the amount). I checked the table to make sure that there were only two...

I have a query that is totaling the dollar amounts based on the type of credit card. I have a patient that was entered twice in the database because they paid on two different balances with a mastercard. When I run the query this particualr patients dollar amounts are twice the amount they...

I have a query that is pulling from two tables that are joined with a one to one relationship by the account/credit card number. I have a patient that was entered twice because he paid two different balances. The query is returning his name twice for each entry instead once for each entry. Can...