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'")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminate repeat values in one field 7
Difference of each row from the next row of one table 2
Find missing entries 1
next date?? 1
Looking up across date ranges in Access 2
Delete Duplicates 2
Select record even with no data (date query) 4
Return multiple records from a single entry. 2

Back
Top