Search results

Where and how should i be entering this in? As you can tell i am a rookie at this stuff.

nz() I am not following you. This is what the language looks like. RBC.[RBC Soil Industrial mg/kg] & IIf((RBC.[RBC Soil Industrial mg/kg]) Is Null,"" & "999999") AS RBC_In_Soil

Hi all, I am trying to create a field that has a combination of two things in it. The first is a field that contains values the second is that if the field is null i wish to add the number 999,999. This is not a problem i can combine the function however it will not keep the formatting as a...

I would have to do it this way because the final field that is presented is no longer a value rather a text field (i am combining a text field with a number field). Can anyone give me direction as how do SQL IIF statements for formating?

Can you do an SQL IIF Statement for formating? I am trying to Bold a value only if the value is greater than a value in another column.

Use the form wizard. Then add each of the tables into the form.

I am trying to conduct a query that is based on two separate queries. Is there a way to that the queries can be related based on multiple fields?

I wish it was that simple... The issue is also enhanced by the following... If there is a result value in the result column then I need that value in the final column... if there isn't a result value in the result column then I need the value in the Reporting Limit column also this is the value...

I essentially have three columns (result field, reporting limit field and lab qualifier field) that I need to combine to produce one Colum to present in a cross tab query. The issue is that I need to only select the min value for each entry (a given analyte, on a given date, for a given sample...

This may sound I guess you could say stupid but...... Is there a way to add a less than symbol in a colum and still keep the value a number rather then text?