Search:

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

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?

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!

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

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

I am working in Access.

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

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

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

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

Corden

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

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

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

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

This is great and works perfectly! I appreciate your help.:rolleyes:

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

Hi Steve,

Great example but I need it as a dropdown list within the cell. For example, on A1, I need a dropdown list that I select multiple people and will show in A1 as (Mary, John, Lisa etc) ...

Hi,

Does anyone know how I can create a dropdown list that will allow me to select multiple values in the same cell. Any help would be great!

Thank you.

VB code worked great as well. Thank you!

Thank you! That worked for me. Appreciate the help. http://windowssecrets.com/forums/images/smilies/cheers.gif

Thank you!

Thank you Don and Tim! This was exactly what I was looking for. Appreciate your help http://windowssecrets.com/forums/images/smilies/cheers.gif

Hi,

I have a SUMIF function that I need help with. I have multiple conditions it needs to look at to pull the sum. I think I should be using SUMIF but I am not 100% sure.
See attached sample...

This is great! Conditional formatting with a formula. How do I adjust the formula to include more than a calendar year?

Hi, I don't see anything attached. Thank you.