Using DLOOKUP to fetch data from table

[rd.prasanna]

Hi All,



I'am facing issue with DLOOKUP,

Actually the program flow is like i have a table of 25 fields, ID as PK and item name, item code and remaining is the date as field name,

below mentioned is the Table heddings,
"ID" "Item Name" "Item Code" "10/29/2013" "11/5/2013" "11/12/2013"

problem is that when im doing dlookup on date getting wrong result...

this is what im using in my codes.
DLookup("11/12/2013" , "tbl_Name", "ID = " & rs.Fields("TRANSID") & "")

thanks in advance
Prasanna R.D

[June7]

Why does table have dates as field names? You have to keep adding new fields periodically? This is a poor design. There is a limit on number of fields in table. Try enclosing the field name in [] within the quote marks: "[11/12/2013]"

[rd.prasanna]

Sure june7,


thank you...

[rd.prasanna]

Yes june7, actually i have add new field periodically... every week...
so i opted for this....

[June7]

You will eventually hit field limit. This is not a normalized design and will be problematic in so many ways.