Referencing Duplicate Field Name in Query

[EddyLLC]

I have a report that gets it data from a query. The query consists of a number of tables and two totals queries. The problem is I have two fields that have the same name, "SumOfLineVal".

My question is how can I refer to one of the sums in code behind the report? The code I have is this:

If IsNull(Field1) Then
lngValue = [qryTotals!SumOfLineVal]
end If

This code does not recognize the SumOfLineVal. How can I reference this field?

Thanks

 

[IGPCS]

why do you name the 2 fields the same? and how can you?

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[Zion7]

Try the dot, not the bang.

lngValue = [qryTotals].[SumOfLineVal]