What you are looking for is the Dlookup function
Table 1
FieldA
FieldB
Table 2
Column1
Column2
Criteria Column2: =DLookup("[FieldB]", "Table1", "[FieldA] = [Column1])
--- In [email protected], Muhamed Faisal
<[EMAIL PROTECTED]> wrote:
>
> Dears
> can you any body hlep me to give some sujestion on a query for its
criteria
>
> i want to make a special criteria in a query and the value of
criteria is to be collected from a table's field
> is it possible??
> any tips on this is highly help ful for me
> regrds
> faisal
> riyadh
>
>
>
____________________________________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
> [Non-text portions of this message have been removed]
>
