Search results for query: *

Hey folks, I think is it better for me to fully explain what I am looking to accomplish. We have a bonus system at work that looks at dates and I need to count the number of business days(Minus any holidays) between those dates. Based on the difference, we will receive a scored percentage for...

Ok here goes. The user will enter a value in columns C and J. Based on those values, I do a few formula's on the side to calc working days between those two dates. Based on the result I display in column P. For example, enter Mar 7/2011 in C14 and Mar 14/2011 in J14. So this sheet simple...

Hey folks, I am getting the #Valve error message in one of my formula's and after doing some research, I cannot determine where it is coming from. The formula starts of with the "=--if(" so I as some people sugguested, I tired to replace the -- with Sum but never had any luck. The formula is...

Ok Great. Thanks for the help.

Good day, It is something really weird going on with the code below. I am tring to validate textboxes on my form. But what is happening is that if I leave any or all of the textboxes blank, access skips my code validating empty boxes and jumps right into the sql down below. Any ideas on this...

Thanks for help for the last one, I have it now. But now I am looking for similar help with regards to a students grade. I have the textbox and I want enter for example 95.52 or 77.52 or 52.22 or even 100.00. Just wondering what type of imput mask I can use for this. I tried 000.00 but if I...

Thanks for the help Bob, but when I go through the input mask wizard I cannot see an option for MM-YYYY. Any idea's?

Good day, I want to have a date format of MM-YYYY on my textbox on my unbound form when the user enters the information. I have searched everywere to find the anwer but I can't get it. Any advice would be great. Thanks

Hey, Basically I have a macro created in Excel that I would like automatically started by using say a command button in Access. I guess to "Call" the Excel macro. Thanks

Hey, Anyone have any advice on how to run an excel macro from Access. For example if i have the file open in excel and I want to jump from Access to excel and run the macro. Any ideas would be great thanks

Hey, Anyone know how to delete the contents of a table through VBA or a macro? Any help would be great. Thanks

Hey everyone, I have a query setup and I only want to return that last three rows of data from the table. Anyone have any advice on how to set this up? I am aware of the the SELECT TOP 3 but not sure if it is possible to just bring back the last 3 records. Thanks

Hey, Anyone know a good access vba book for beginner's? Note: I am new to vba. Thanks

Hi pbbriggs, How's it going? I changed the gap width to 500 but still the bars reamain small. I have the overlap set to '0'. Any ideas?

Hey, Anyone know the property to enlarge the bar's on charts.I was thinking options under the Format Data Series but that didn't work. thanks

Hey, Just wondering if anyone can notice a problem with this expression. I am getting an aggregate function error. Expr2: Sum([tblstj]![acd_calls]) / [tblstj]![acd_calls] Thanks

Thanks for you time RottPaws, I will try the select query.

Hi, I apologize for not explaining the post clearly. Here is the SQL, I think it may a divide by zero issue but I cannot find it. TRANSFORM Sum([tblstjastats]![i_acd_time]+[tblstjastats]![i_acw_time]+[tblstjastats]![i_acd_other_time])/Sum([tblstjastats]![acd_calls]) AS [=AHT] SELECT...

Hi everyone, I have a crosstab query created and when I run it I get an "Overflow" Error appear. Anyone have any ideas why this is happening? Thanks

Hey, Just wondering if this is possible. I have two queries with two fields in each. These queries will consistently have 48 records in each. Is it possible to export these two queries into excel on the same worksheet "side by side"? I would assume VBA would be used. Any help would...