Help with Dlookup needed

[Bokazoit]

I have this function:

=DLookUp("[LYFY]";"DVH_krydstabel";"[Market] = DAGLIGVAREHANDLEN EX. COOP")

But it gives me an error (#error) in my report

DVH_krydstabel has these coloumns:

Market, SegmentID, DMLY, DMTY, LYFY, YTDLY, YTDTY

The Dlookup function should give me the value of [LYFY] in the tabel 'DVH_krydstabel' where [Market] = 'DAGLIGVAREHANDLEN EX. COOP' and SegmentID equal the current Segment shown in the report.

Tx ;-)

 

[Bokazoit]

This is weird, now the formula works!?

=DLookUp("[YTDLY]";"DVH_krydstabel";"[Market] = ""DAGLIGVAREHANDLEN EX. COOP"" AND [SegmentID] =""" & Reports!report2!Segment & """")

I have no idea why?

 

[mordja]

Bokazoit,

Im glad, it worked for me and Id run out of explanations why it wasnt working for you .

Mordja

 

[Bokazoit]

I have just made an iif function, so that when DVH is shown it doesn't lookup anything

Well I don't know if I can explain myself good enough, but I have DVH which consist of most of the revenue sold though retailstores in DK.

I also have data from 6 of the greatest retail-chains in DK. I use the data to see how much each of the 5 chains gross-sales is. I then compare that to DVH. So if Retail-chain1 has a 50 million revenue in segment1, and DVH revenue in segment1 is 115m. Retail-chain1's marketshare is 50/115 = 43% in segment1. That's why I need to recall DVH for each segment, for each retail-chain.

I'm not a shark at Access, so prolly there is a better way to do this, but I don't see it though

Hope You see my point now, and if You do and have a better idea. Then don't hold back ;-)