multiple values from a temp table

[1jet via AccessMonster.com]

Hi all,

Been stuck on this for a while...was hoping for some more help.
I have a temporary table like such

TS_Date Project_Name Hours_Worked
19/10/2008 Dalkeith 0
20/10/2008 Dalkeith 4
21/10/2008 Dalkeith 4
22/10/2008 Dalkeith 4
19/10/2008 East 0
20/10/2008 East 4
21/10/2008 East 4
22/10/2008 East 4

Now if I wanted to find the Project_Name for criteria TS_Date = 22/10/2008, I
cannot use Dlookup bcos there's going to be 2 results.
Dalkeith and East (obviously).

How would I get these two values into two separate variables?

Cheers

 

[Alex Dybenko]

Hi,
I think best option - to open recordset and get both values (or perhaps
more) from it

see an example opening recordset in access help

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com