criteria in expression builder

[Dean Collins]

Hi,

I have a Form that is populated with a query. There ia a
text box representing each Year below.

-------------------------
2000 2001 2002 2003

------------------------------
My query produces the data:

Dept, Year, Number
ABT 2000 435
ABT 2001 420
ABT 2002 209
ALV 2000 89
ALV 2001 109
ALV 2003 106

Is there an expression that can be used to populate each
field using a Dept and Year criteria in the control
source of each text box? without a criteria the first
data in the query is chosen. If this is not possible then
can some one show me an alternative way to achieve the
same results.

many thanks
Dean Collins

 

[[MVP] S. Clark]

=Dlookup("Number", "TableName","Year=2000"


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-