Recent content by jplink49

I figured it out. This is what I did to achieve what I wanted to do: 1. I went to the [ACMT_Field] field and entered this expression, =Dlookup("[ACMT]", "Tablename", "Left([ACMT], 3)='The'") 2. I did this and my analysis comment "The actual concentration is..." pops up in my [ACMT_Field].

Gemma... so I should go to Reportheader-->Rightclick-->sorting/grouping--> then create a group footer?

I have a field [ACMT] on my report that holds analysis comments; it [ACMT] resides in the Footer section of my report. The problem is my analysis comments do not show on my report. I learned that the Footer section only displays values in the last record of the table (the record source of the...

I have a field [ACMT] on my report that holds analysis comments; it [ACMT] resides in the Footer section of my report. The problem is my analysis comments do not show on my report. I learned that the Footer section only displays values in the last record of the table (the record source of the...

Hey Wayne, Thanks for your help. I have noted your code.

Ok.. I understand. Thanks again Chergh.

Hey Chergh... How can I include the > greater than sign in that code. (Your code works perfectly when handling the < less than sign; however sometimes we have results like "> 5" etc.. How can I modify the code to handle both signs in the code?

Chergh That Did It! Thanks A Lot!

Chergh, I've tried your code. I get this error message: Compile error: Sub or function not defined, and it's getting hung up on the "clong" part of the code{---Format(Round(clong(strvariable), 1), "0.0")---}. Do I need to go back and define a function in the beginnig of my code. I am a novice...

Chergh, this is what I want it to do. I'm about to try your code now.

Wayne, thanks for your reply. I see your code, but I need for it to retain the <> signs if they are there. Meaning to display "< 1" or "> 5".

Yes. Sometimes there are values such as "<1" or ">5". And when this is the case, I want Access to keep the sign. Display "<1" or ">5".

Hello, I have code that is doing what I want it to do on my Report except when it comes across the occasional >,< signs.{For "Ammonia", when there is a number less than 1, put "BDL", for all other digits round to one decimal place(that's fine!)}. {For "CBOD", when there is a number less than 1...

RuralGuy It worked. Thanks a lot!

Thanks RuralGuy! I'm about to try this code now. I'll let you know how it goes.