Ps mane suveike.

"Laimis"  wrote in message news:i9p01v$5r9$1@trimpas.omnitel.net... 

Linas Petkevičius rašė:
> ItemPrice: DLookUp("Price";"Param";"Type=Left(Name,2)")

Ne(su)veiks. Bent jau MSACC2K3. Reikia dinamiškai formuoti:

SELECT Sarasas.Name, Sarasas.Qty, DLookUp("[Price]", "Param", "[Type]=" 
& "'" & Left([Name], 2) & "'") AS ItemPrice FROM Param, Sarasas;

Tik apskritai, kam čia tas DLookUp (įrašai bus kartojami, dar teks 
grupuoti...):

SELECT Sarasas.Name, Sarasas.Qty, Param.Price AS ItemPrice FROM Sarasas, 
Param WHERE Param.Type = Left([Name], 2)