Search results

JoeyY, I thought it was working right but it was brought to my attention that, this function is giving blank result if there no data instead of zero. *** I solved this one: =iif(Avg([Flexible]=0,0,DAvg([Flexible],"qryYTD Rollup",[Flexible]>0)) *** Second, my test report have 10 line item...

DAvg () shows Blank instead 0 when there's no data Gentlemen: I have a YTD employee data report, from Jan 2008, I added a new category called Flexible Tasks, previous to that date it default to zero. I used DAvg () to get the average total, however if there is zero data for 2008, the formula...

Jwood29, I appreciate this direction, IT WORKS!! Although our situation is not exactly the same but close, I am dealing with integer and decimals. My text box which contains: =IIf([OP1]="",[Create],formatnumber([OP1],0)) now contains IIf([OP1]="",[Create],[OP1]), Thank you to Fifty2One. The...

Hello Guys, It's half working, I tried various configurations, Here's what my table and report formats. . . . . The dots are for spacing only. Table contains: EmpId, Month, OP1, Create, OP2, Treat, OP3, Act, etc. AA . . . Nov07 . . . . , 0.010, . . .,0.010,. . . . , 0.010 AA . . ...

Hello Guys, Please see next one below. Thanks,

Hello I password protect the module codes. If I update the codes and then protect it before saving, with a message saying the changes cannot be save because the module is password protected (not verbatim). Am I doing something wrong or any better way? Thank you.

My apology, should have been in Access.

Hello, I have two columns on a table, one Col A is an integer with zero decimal places and in Col B is formatted to 3 decimal places (0.020). On the Report I have a textbox with data source formula: = iif([Col A]= 0, [Col B], [Col A]) If I format the textbox with 3 decimal place and the...

Hello, I am wondering why there's no taker? Can anyone help! Thanks

Hello, I have two table columns, one Col A have zero decimal places (integer) and Col B have 3 (0.020). On the Form, the textbox's data source = iif([Col A]= 0, [Col B], [Col A]) However, if I select decimal format 3, the interger will result to 2.000 while if it's the other it will cut it...

Oh Hello, I password protected my codes on the Visual Basic Editor, however, the users cannot save the file. Is there a better way to do this? Thanks,

To: Pbaldy, georgedwilkinson You're the men! Another rescue accomplished, thank you! I have declared ID as a string in numereous occasions and sometimes I don't state the type, just Dim ID and it works. The value is associated mostly to employee ID, a text (alpha-numeric), that's why it didn't...

Immediate window: SELECT * FROM [tblSupervisorCurrMnth] WHERE [SuprvID]= lh For simplicity I changed the table to tblRecord and SuprvID to SID. The = lh is the ID on text7 to find on the table Record in what location is the user is from then it will continue to run a Select Case. Thanks

After this line, F8 will jump to Error Handling message. I forced it to go resume next. The Site = rs (4). value have the object variable not set message. If I let it go to Error Handling, the message will state "too few parameter. expected 1." Thank you.

Hello After spending a lot of time figuring this out, I think it time to call on the experts. I can't make my sql work on rs(1).value. I keep on saying "object variable or block variable not set" I copied one in my module that works but won't work here. I am lost in translation. Private Sub...

JoeyY, I WORKS!, thank you. I have seen it but didn't have chance to apply to a situation, similar to seldom use SumIf. Wonderful! Thanks, Bobby1st:)

Hello, I have an existing table with data and I added a new column with a default to zero. When I query the table-column the results will show zero content for the previous dates and data for the current dates. I have a " =Avg([theColumn]) " on a textbox. The result in not correct, it counts...

. This is the best solution however, it won't work for there's a lot of variables. You mentioned append, I thought of saving the report data on the same table (tblMonth) and append to tblYTD, this won't work because the table is key (no dups). I tried this also, while the multiple reports is...

. This is the best solution however, it won't work for there's a lot of variables. You mentioned append, I thought of saving the report data on the same table (tblMonth) and append to tblYTD, this won't work because the table is key (no dups). I tried this also, while the multiple reports is...

Sorry, I think I deleted your last reply. The tblMonth have the raw stats, say Apple sold by employee at $1.10, this is pulled to the report and formulas applied to show cost 40%, ($1.10 x .4)= $.44, profit = 1.10-.44=$0.66. What is save on the tblYTD is the data $0.44 and $0.66, then report...