Search results for query: *

Have departmental Excel worksheet that have 4 columns; Name, Phone No., Supplies that I have, and Supplies that I need, and Comments. Note, there are 75 rows that correspond to each of the 75 employees in the department. Is it possible to have the "Comments" field populated with the name and...

Data is not in all of the rows 5 - 56000, Some of the rows between 5 and 56000 are blank.

Did take a look at using MS Query for the issue. However, is it possible to use a combination of sumproduct and nested if statements to determine if a particular MS Excel cell with dates is before or after another date?

Have a six-column Excel worksheet that have approximately 26,000 records in columns A through C and 28,000 records in columns D through F. Columns A through C is the admit and discharge dates for the employees at Hospital 1 and columns D through F are the admit and discharge dates for employees...

Have a MS Excel 2002 pivot table with three row fields; Chg Amt, Paid Amt, and Nbr of Visits and column fields that consist of the 12 months for 2007. Is it possible to create a calculated field that will divide the value in a particular cell within the pivot table by the respective membership...

Creating a QBF in MS Access 2002 and interested in displaying the results in a listbox that is at the bottom of the form. Upon displaying the results, I would like to give the end user the option of transferring to Excel, text or email. Is this doable? How should I accomplish?

Have pivot table where the page field is Vendor Name; the column field is service_month and the data elements are Sum of Paid, and Sum of Units. There are 12 service months - from Jan through Dec. What I am trying to accomplish is to insert a column after each service month that displays the...

I can view the reports while at work but cannot view on the laptop from home. I have MS Access 2002 at work and MS Access 2003 on the laptop. References on the computer at work are; Visual Basic For Applicatons Microsoft Access 10.0 Object Libary OLE Automation Microsoft DAO 3.6 Object Library...

Not able to resolve a run-time error using MS Access 2003. Upon clicking on a command button on a MS Access form, I receive a run-time error. Upon accessing the code, the line beginning with DoCmd.OpenReport... is highlighted. Any idea on the source/resolution of the problem? Private Sub...

Spoke too soon! It appears that the formula is working. Thanks.

Well, it didn't work - There are 1s populating each row in the column.

Wow! That was quick response! Thank you, I will try the suggestion.

Have the following in an Excel 2003 spreadsheet: MbrID---VisitDate---VisitNumber 2684----1/4/07 2684----1/6/07 2684----1/10/07 4873----2/1/07 4873----2/5/07 4873----2/15/07 Is there any method available where the column titled "VisitNumber" can be populated with the number of the visit? For...