Search:

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

Page 1 of 4 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thank you very much! I will give this a try!

    Thank you very much! I will give this a try!
  2. How to send Access forms through Outlook email?

    Hi,

    I have an access database with a compensation statement for each employee. I need to send the statement to each employee via outlook email. I can PDF them but how do I send each one out...
  3. Replies
    12
    Views
    646

    The weird quotation is actually a hyphen in their...

    The weird quotation is actually a hyphen in their last name. What should I do?
  4. Replies
    12
    Views
    646

    Hi Rory, I am trying to use what you sent me...

    Hi Rory,

    I am trying to use what you sent me with my new dataset but I am getting this message "Syntax error (missing operator) in query expression ‘[PersNo]=10073210 and [Last name] = “D’amico”...
  5. Replies
    6
    Views
    379

    Try moving the table array to begin in Column A. ...

    Try moving the table array to begin in Column A. Sometimes, the vlookup does not work unless the unique key is in the far left of the spreadsheet. Good luck!
  6. Replies
    12
    Views
    646

    Hi, Rory gave me an awesome formula that...

    Hi,

    Rory gave me an awesome formula that worked perfectly in excel. However, I am looking to link my file and create the query in Access so I can always pull the most recent Job Tenure. Is there...
  7. Replies
    12
    Views
    646

    Thank you Rory. The formula worked perfectly in...

    Thank you Rory. The formula worked perfectly in Excel! Is there a way to add this formula into a query in Access? I would like to automate the job tenure in my Access database.

    Thanks again.
  8. Replies
    12
    Views
    646

    Need help with Min Max and Group query

    I have numerous records that repeat itself. What I am trying to do is determine how long each employee has been in a specific job. I typically would group by job code and do a min max on the start...
  9. Replies
    0
    Views
    391

    Automate Organizational Charts in Visio

    I have an access 2007 database that I created to link to an excel file that gets refreshed nightly. Then I have visio 2007 charts that are generated off the access query that creates the layout file...
  10. Replies
    4
    Views
    985

    Thank you for your support. It does work as you...

    Thank you for your support. It does work as you suggested but I need to also add department. But when I include department into the group by, it changes the dates for my job data. How can I...
  11. Replies
    12
    Views
    2,342

    Hi, I am getting a "overflow" message when I...

    Hi,
    I am getting a "overflow" message when I replace the table1 with a new table1. Do you know why I am getting that message? Is there something else I should be doing first?
  12. Replies
    12
    Views
    2,342

    Oh wow, so sorry, i had not noticed you had...

    Oh wow, so sorry, i had not noticed you had provided a response. I need to turn on my notifications... I am going to give it a try and getBack to you. Thank you in advance!
  13. Replies
    4
    Views
    985

    Need help with query in Access 2007

    Hi,

    I have been driving myself nuts trying to get the results I am looking for with no prevail. So I am hoping someone can solve my issue...
    I have a table in SAP called organizational table...
  14. Replies
    12
    Views
    2,342

    Hi, Here is the sql statement in Access I am...

    Hi,

    Here is the sql statement in Access I am trying to do based on your query. What you call T1 works fine but what is T2? Is that the same table added again? How do I do the UNION? Something...
  15. Replies
    12
    Views
    2,342

    I am working in Access.

    I am working in Access.
  16. Replies
    12
    Views
    2,342

    Help with a query

    Hi,

    I am hoping someone can help me from the lounge with my query. I can't seem to figure out how to change my query to get the results I am looking for. I am using grouped by all the fields...
  17. Thank you so much. I did not know about the...

    Thank you so much. I did not know about the ctrl-shift-enter. I would of been trying for another two hours. You are awesome!

    Corden:)
  18. Need Help with a Index~Large~Row nested function

    :o:Okay... I have finally given up after 3 hours of trying to figure out what is wrong with my formula. I have a spreadsheet that I want to use to balance my checkbook. It is set up so that I know...
  19. Thank you so much!!!! It worked. Very...

    Thank you so much!!!! It worked. Very impressive.

    Corden
  20. How do I incorporate multiple conditions? For...

    How do I incorporate multiple conditions? For example, I would like to say, If B3= Rep and C3 = CV and (D3 contains 1.1 or 1.0 or 1.2 or 2) and R3>=50 or s3>=50 then "YES" otherwise "Rule Does Not...
  21. Need help with a formula for multiple conditions

    Hi,

    I have a spreadsheet that contains multiple formulas. Overall the objective is to identify the individuals that are scheduled for a promotion. The catch is it is based on multiple...
  22. Replies
    4
    Views
    3,141

    Hi, Looks like this article is describing how to...

    Hi, Looks like this article is describing how to export the contacts into Access. I am looking for how to export my emails from outlook and load them into Access so I can group them, create reports...
  23. Replies
    4
    Views
    3,141

    Loading my Outlook emails into Access

    How do I load my company emails from outlook into an Access Database. I have 8 years of emails that I tend to go back into but I need to save space on the server. My computer runs slow. I have...
  24. Thank you!

    This is great and works perfectly! I appreciate your help.:rolleyes:
  25. Help with a conditional formatting formula

    Hi Don,

    I am trying to use the conditional formatting swim lane formula but I am having problems figuring out how to use it for multiple years on one row. Moreover, we work on a fiscal year so...
Results 1 to 25 of 99
Page 1 of 4 1 2 3 4