Add a field for calculation in current report

[Zack Barresse]

Hi all,

I have a report based on a query I built. The report works just great.
Although I would like to add a textbox next to the ones currently on my
report of the calculated value which the query was built off of. Right now
it just reports the actual table value. Is there anyway I can do some sort
of Lookup in a query? I just want to display two fields added together
based on a specific 'Well' and a specific "SampleDate' field(s). Is this
doable? Thanks.

 

[Duane Hookom]

It's most likely doable. You would need to better describe "some sort of
Lookup".

 

[Zack Barresse]

Hi Duane,

I also posted this in msft.p.access (sorry I didn't mention it) in which
Douglas Steele led me to what I needed for a solution. I got it working
beautifully, even added some conditional formatting (for the first time). I
am very pleased with it and it will be a very valuable asset to have for our
database. Thanks.

--
Regards,
Zack Barresse, aka firefytr (MVP: Excel)

It's most likely doable. You would need to better describe "some sort of
Lookup".

 

[Duane Hookom]

The "Man of Steele" is very good at this MVP thing

--
Duane Hookom
MS Access MVP

Hi Duane,

I also posted this in msft.p.access (sorry I didn't mention it) in which
Douglas Steele led me to what I needed for a solution. I got it working
beautifully, even added some conditional formatting (for the first time).
I am very pleased with it and it will be a very valuable asset to have for
our database. Thanks.