Sir,
while we using Dlookup function only first data which accept the ctiteria
is appearing, there is any way to display all critera in the same function
Regards
Faisal
Riyadh
----- Original Message ----
From: bdloving <[EMAIL PROTECTED]>
To: [email protected]
Sent: Friday, February 22, 2008 8:28:42 PM
Subject: [ms_access] Re: criteria in query
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] ps.com, Muhamed Faisal
<muhamed_faisal2000 @...> 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]
>
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
[Non-text portions of this message have been removed]
