Vlookup?Dlookup

  • Thread starter Thread starter Maxwell
  • Start date Start date
M

Maxwell

Im new to access and need to do a "vlookup" or what ever
the comparable formula is from excel.

I have a table column names Date counter (which is
wk1,wk2, etc...going down) Then beside it I have the real
date (01/01/03 - 01/07/03). So WK1 = 01/01/03-01/07/03.

I need the formula the tells me lookup WK1 and pull the
range dates.

Thanks in advance
 
Pull the range of dates....as a string? or as individual dates?

Code below returns the string value.
DLookup("RealDateFieldname", "TableName", "[Date counter]= 'WK1'")
 
Back
Top