Search:

Type: Posts; User: pooja; Keyword(s):

Page 1 of 9 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    319

    I'm having a horrible time with an IF/THEN...

    I'm having a horrible time with an IF/THEN statement in a complicated timecard. What I would like is if is X45 is greater than 0, then AA39 would copy the value from Y39.

    Formula I'm trying to...
  2. Replies
    6
    Views
    583

    Sorry about that! But your answer gave me an idea...

    Sorry about that! But your answer gave me an idea on what to do. Thank YOU.
  3. Replies
    6
    Views
    583

    Hmm, that didn't work for me. I'll keep playing...

    Hmm, that didn't work for me. I'll keep playing with it though until it does! I have one final question. If in the final version of this multi-query, I want to combine the fields in Dept, Div, Func...
  4. Replies
    6
    Views
    583

    Certainly does. I had to play with it a bit since...

    Certainly does. I had to play with it a bit since I was off by about a million dollars or so in the 'real' database but figured it out. Created a separate query to sum by account. What is the easiest...
  5. Replies
    6
    Views
    583

    I have the weirdest request. On the attached...

    I have the weirdest request. On the attached mini-db, I've put three tables and a query. I need to know how to create an append query that will take the information from the last column...
  6. Thank you. I will try this again. Didn't do the...

    Thank you. I will try this again. Didn't do the last step the last time I tried it.
  7. Thank you for the tip. That is one great macro...

    Thank you for the tip. That is one great macro that I can totally put to use! As a FYI to others, it turns the Reviewing toolbar on automatically and sets it to Track Changes everytime the doc is...
  8. I have a document with over 200 pages that is...

    I have a document with over 200 pages that is linked to various files in Excel - all of them as "Excel Worksheet Object'. The only thing that ever changes is the parent folder year (see file folder...
  9. Thread: IIF Formula Help

    by pooja
    Replies
    4
    Views
    691

    That totally worked! Thank YOU so much. Pooja

    That totally worked! Thank YOU so much.

    Pooja
  10. Thread: IIF Formula Help

    by pooja
    Replies
    4
    Views
    691

    It's almost perfect (and exactly what I thought...

    It's almost perfect (and exactly what I thought it should be)! Thank you for trying. The problem with this one is that I'm still getting numerous rows related to the exact same Account. For some...
  11. Thread: IIF Formula Help

    by pooja
    Replies
    4
    Views
    691

    I need some assistance translating the formula...

    I need some assistance translating the formula from Excel to Access. The variations of IIF in Access are not giving me the correct data. Please see screenshot of the query and the attachment for the...
  12. Replies
    1
    Views
    408

    Outlook Calendar Invite Button (2003 SP3)

    Is there anyway to add a 'button' within Excel that automatically picks up a date from a column and creates an Outlook calendar invite? Basically, I have a list of dates regarding next year's budget...
  13. Replies
    1
    Views
    386

    Only allowing one person (2003 SP3)

    We have a cash receipt database that sits on a local network. Recently we switched servers and ever since, only one person can access the database at a time. Prior to the switch, this was not a...
  14. Replies
    6
    Views
    519

    Re: Automated Form (2003 SP3)

    Same local network.
  15. Replies
    6
    Views
    519

    Re: Automated Form (2003 SP3)

    Sorry, I should have been more specific. This form will be used multiple times by quite a few people throughout the day. And the data needs to be captured so that we don't have to print out the...
  16. Replies
    6
    Views
    519

    Automated Form (2003 SP3)

    I'm looking for ways to automate the attached form. All suggestions are welcome. I added the type of fields needed. The current process for this form (in paper format) is to have a cashier fill it...
  17. Turn on 'Out of Office' automatically (2003 SP3)

    Is there anyway to setup the 'Out of Office' assistant to automatically turn on every other Friday? We have a flex fri that we're going to implement for cost savings and need to make sure that people...
  18. Re: Global Address List - Custom Searchable Field

    We actually use the Lookout addin for Outlook which gives us SOME additional functionality. No other development is intended.
  19. Global Address List - Custom Searchable Field (2003 SP3)

    We are trying to resolve an issue on using our Global Address list within Outlook (Exchange 2003) to also have a searchable capability to find our Spanish speakers (very important where I work). Has...
  20. Replies
    1
    Views
    453

    Count Text Values (2003 SP3)

    On the attachment, I have four tabs. On each tab, I need to count each instance of a word that repeats. For example, on Tab CE in Column G (Pollu_Discha), I have two instances of 'Stormwater' so I...
  21. Replies
    4
    Views
    464

    Re: COUNT function (2003 SP3)

    Using the above steps as a guide, I was able to get the data we need out. One additional question, I've made 'Make-table' queries for everything we need as an output from the database and created...
  22. Replies
    4
    Views
    464

    Re: COUNT function (2003 SP3)

    Thank you and apologies for the large pic!
  23. Replies
    4
    Views
    464

    COUNT function (2003 SP3)

    Edited by HansV to reduce picture in size - please don't post pictures larger than 640 x 480 pixels.

    Is there anyway to do a COUNT function on the instances of a VALUE in the cell? Basically I'm...
  24. Replies
    3
    Views
    495

    Re: Odd or Even Year Formula (2003 SP3)

    Thank YOU much! I'm going to try them all out in my giant workbook and will let you know how it goes...

    pooja
  25. Replies
    3
    Views
    495

    Odd or Even Year Formula (2003 SP3)

    I have a weird one. On the attached file, I have two tabs.

    1. On the Fleet Inventory tab, I would like to have a formula that will take the year of the model (Column G), refer to the last DIGIT...
Results 1 to 25 of 210
Page 1 of 9 1 2 3 4