Search results

Thank you very much for you help it works nice have a nice weekend Calucho:D

:banghead:Hello to every body; I have a question regrad to Dlookup() functio; I Have this =DlookUp("[Esti-Time]",“K-Sumary-Time-V2", "[AssemID] = '" & AssemID & "'"). but i got this message You may have an Operand without an operator. thenk you for you help Calucho..:confused:

Hi I try to do these formula but I never got the rigth value: just the #error in the field that I wnat to put the value. I use CDbl function and Val function but nithing. =IIf([Flag]=1, CInt(Count([code])) /DLookUp("[1-Accept] )+ CInt(Count([code]))", "Value Query", "cdbl([E-Date]) =...

Hola: I have a table with this value PartID, Supp, Ftlot, Qty, UB-Date, Flag It is my question is How I can Highlight the hold record when the condition is true IIF flag = “G”, Highlight the record in my report or there are an option in the conditional formatting in the format to do this for me...

Hi, I would like to Apply a font color underline font to the Row of field with an If condition. How I can build the IIF statement that change the font in my reports. IIF(Flag]= "G",??????????). or there are another solution to do this please can you advice me how to do this. Thank you Calucho:mad:

Hi Taruz, Thank you for you help the second option work perfect for my Dlookup. and it is running very nice in my report. Thank you very much for your help. Calucho

hi; sorry I type wrong the table name in the Dlookup it is =DLookUp("[VL100]","Values_T”, “[E-Date] = & #04/06/2012#") I did Like this =DLookUp("[VL100]","Values_T”, “[E-Date] = #04/06/2012#") an got the same result #ERROR in the field in my report. Thank you Calucho

hi; I create a report and I try to use the DlookUp function; I have a table (Values_T) [ID], [Accepted], [Reject], [VL100], [Vl600], [E-Date] in my reports I have field txtCalc I try to brinf the value of [VL100] to my report and make some calculations, and it is the function...

Hi, Hi, Can you tell me what is wrong with my function DLookUp that doesn’t print no values just a #ERROR I have a table with these Fields in my Table (values_T) [ID], [Accept], [Reject], [MR100], [MR600] and [E-date] in this table I have information for every week. In my Reports I create...

hi, just a single employee; I just want to display each time want the data entry enter the hours; she have a chance to see the counting and at the end she have to mach the hours that she entered. I try to reduce to 99.99% error of data entry. Thank you. Carlos.

hi, I have a form to enter the hours of work for employee; I want to know how i can add these values each time that i enter the information in the form and the same time show me in the form the total of hours entered. These means have a counter of hours and show the subtotal on the form. Thank...

hi Rain; thank you for you answer but I still have the same problem I make the change that you sugest me but; it does not work i got the same result. Thank you carlos:confused:

Hi, I have this problem with the iif statement =IIF([Flag])=6,"M6000","M1000"):eek: the problems is on my table I have flag 1 and 6; but when i run a report in some Range of date it recognize the flag =6 and flag=1; but in some ranges of date does not recognize the flag 6; just recognize the...

Hello; Thank you very much for you help Carlos

Hi; I have a form for Data Entry in access 2010 I want that the cursor come back at the first position of the field on my form whe I finish to enter the information. theree is a option for these?? Thank you for you help. Carlos

hi, thank you for you help; I find another way to do these: convert the value of 0.00 to NULL =AVG(IIF([Accept]=0,NULL,[Accept])) it work fine. Thank you for all you replay. Carlos

hi; sorry may be I can express my self well; I create a reports. I use in the report the Average formula; but I have some values with 0.00 and when I aplly the formula of average it count the 0.00 values and the average is not accurate because the average count the 0.00 like a value and it is...

hi; Thank you for you answers; how use a IIf condition for the same problem a report; =AVG(IIF[accept]=0, here what will be the Thrue condition; Thank you

Hello; Some body can tell me how Omit the zeros from the average function formula so I can get the accurate average of my values. Thank you for you help Carlos