Search results for query: *

Works like a charm! Thank you,

Hi All, I would like to figure out how to identify a future date using an identified date and adding only work days in Excel. So for instance, today is 7/15 what date would it be 20 work days from now (M-F)? Thank you for your help. Sandy

Hi All, I have an Excel spreadsheet with the following conditional formatting set in a macro. When this macro runs it highlights fields that are null. How can I only highlight those fields that are populated? Here is what we have: Columns("H:H").Select Selection.FormatConditions.Delete...

Sorry about that. I meant for this to be a new post and not a tag onto where I placed it. Sorry...

Hi All, I have an Excel spreadsheet with the following conditional formatting set in a macro. When this macro runs it highlights fields that are null. How can I only highlight those fields that are populated? Here is what we have: Columns("H:H").Select Selection.FormatConditions.Delete...

Easy as that! You guys are so awesome. Thank you for the speedy reply! Sandy

Hi All, I understand how to highlight every other row in an Excel spreadsheet using conditional formatting and the mod() function. Is there a way to highlight every other data grouping such as by State? My spreadsheet fields are as follows: A: AgencyName B: AgencyAddress C: AgencyCity D...

Thank you for the suggestions! Sandy

Hi All, I am looking for a program comparable to GeoAccess. I need the ability to develop maps using data I currently have housed in Access. Any suggestions?

Bob, Thank you for such a quick response. When I use this code the query returns all records that satisfy the query criteria and has a value in the cbofederalbuilding field. Since this is not a required field some records will have a Null value for this field. I would like to be able to have...

...criteria. Here is what I have tried as cboFederalBuilding field query criteria: IIf((IsNull([forms]![sv search menu]![cbofederalbuilding])),Like "*" Or Is Null,[Forms]![SV Search Menu]![cboFederalBuilding]) When I run the query I receive an error message stating that the query is too...

Thank you! The isnull did the trick! I appreciate your quick response. Sandy

Hi All, I have a form that I use to run roll up reports by Colleague, Team or Auditor. The team and auditor report is the same but the colleague report is different. I would like to use the same form and report button to run either report. Here is the code I am using for my report run...

Hi All, I am trying to append some data from one database to another using an append query. The database I would like to append to has a password and I keep getting a "Not a valid password" error when I run the query. This is what my file name looks like in the append file name box...

I have two sets of dots for each of the ranges, a total of 10 dots. There is one dot represented for each percentile. For instance, there is one dot for 95% instead of 4 dots. When I hold my cursor over the dot it will tell me that that dot represents 4 however this is not useful once the...

Sorry, I misunderstood your previous post. I would like to see 10 dots. I would like to see where the large clusters of dots fall to see if we can move a standard up. Thank you,

The XY Scatter. Thank you, Sandy

Here you go: Rollup: Range 100 99 98 97 96 95 February 0 0 3 2 1 4 March 0 0 2 1 3 1 Or All Data: Feb March 98 98 98 98 98 97 97 96 97 96 96 96 95 95 95 95 95 Thank you,

Hi All, I am trying to put together a scatter gram in Excel to show how many colleagues are falling within a particular percentile. My range is from 85% - 100%. I have tried to use a roll up of my data and the full data set and I get the same result either way, one dot for each percentile...

Hi All, Is there a way to count how many times a letter appears in a field? I will have a string of characters such as PPPPLLLLPPPPPBBPPPP and would like to have one query that will tell me how many Ps, Ls, Bs and so on are in that field for each record. Thank you for your help! Sandy