Search results for query: *

Building on my description above ... PLAN LOCATION DESCRIPTION QTY 401 A1-A2 Dig 5 401 A1-A2 Dig Additional 25 402 A2-A3 Place 7 402 A2-A3 Place Additional 49 The idea is that there is a rate paid for the first operation done...

=Description 1 QTY / Description 2 QTY

Hello ... I create a pivot table from a data spreadsheet no problem. When I add a calculated item I start running into problems. My Data basically looks like this ... PLAN LOCATION DESCRIPTION QTY 401 A1-A2 Dig 5 402 A2-A3 Place 7 And so on ... when I...

This is great help guys ... appreciate the response ... I'm working with now to see how this will work for me .. As a side question ... if there is some math I want to perform on the data in the pivot table ... is there a way I can add that as a column that is part of the pivot table?

Hello, need some help/guidance... I have a spreadsheet, that spreadsheet basically summarizes work operations on a construction drawing. The idea is that I have someone go through a workplan, and populating this spreadsheet based on the drawings. My columns are somthing like "PLAN DESCRIPTION...

Good Afternoon ... I have two columns ... what I want to do is compare the two columns, for every entry in column A that isn't in column B I would like to copy that data to a third column ... Anyone help?

Ok ... here's the situation ... I have a column1 with several repeating names, what I want to do is create another, column2, with every distinct name listed (Kind of like the dropdown menu for the AutoFilter. Any suggestions??

Thanks guys ...

And there it is ... thanks much ... just as a matter of curiosity ... what if I wanted to display the 3rd column ??

Hmmm ... still not fixed ... the combo box object seems to be displaying column 1 ... It would appear that I'm having difficult displaying column 2 (Which contains my meaningful data) ...

Hello ... I have a lookup field with 3 columns. The correct column is getting stored on the base table, However the field on the form is displaying the ID number ... not the actual field data ... I know this is really easy to fix, I'm just having a mental block this afternoon ... Kevin

Ok ... how do I set up the conditional formatting such that the field is bolded if it has been changed within the last week ??

Hello ... I track many projects for my client using Microsoft access. Every friday I export my tables into a Microsoft excel file for their use (As that is what they are familar with). Traditionally they used to get new updates (I.E. Updated dates and comments) bolded for anything added...

Lord .... sorry about that ... it's one of those days ... I'm using Outlook 2002 (SP3) in an XP environment ...

Hello ... Not sure if I'm doing something wrong ... looking for some help. When I "Find" an e-mail in my inbox is there any way that I can then copy that to one of my local folders? When I try with the search results I get an error message saying "Can't move the item." Any idea why this is...

Good Afternoon Folks ... I have a "Check Box" control in Excel 2002. Is there a way I can change the check mark to an "X" ... or maybe somehow cause the fact that the box is checked become more apparent? I only ask because I have had people complain that the check mark is hard to see when a...

That does it ... great ... thanks ....

Ok ... I have a dropdown made already with a list of Names (7 of them). Based on the name you pick I would like the address cell to auto populate to the correct address.

Good Morning, I am trying to auto populate some cells based the value chosen in a drop down control. Is this possible in Excel ??

Hmmm ... ok ... I've been trying to get this straight but I don't have formal VB or any Access training in depth. I've read these posts and am trying to get my head around them ... What I'm trying to do ... I have a final Completion Date (CompDate), I want to "Schedule" various target dates...