Hi friends,....
I get something funny job regarding dlookup function, i also know how to use Dlookup in my database but when i need to use dlookup function, what i will thinking first is performance of my Database because when we use Dlookup function is will effect efficiency of performance database, so do you have any idea to solve this matter either in query or module? Please see carefully for this sample table:
Fields: Date / DE1 / DE2 / DE3 / DE4
15/03/2001 15 12 14 12.5
29/03/2001 30 25 28 26
15/04/2001 39 36 37 36
30/04/2001 45 43 44 44
so i need make comparison between BeginDate and EndDate for DE1 / DE2 / DE3 / DE4 this mean EndDate for DE1 compare with BeginDate for DE1 and so on.
If is possible please let me know, you assistance must me appreciated.
Best Regards,
Haj1503
I get something funny job regarding dlookup function, i also know how to use Dlookup in my database but when i need to use dlookup function, what i will thinking first is performance of my Database because when we use Dlookup function is will effect efficiency of performance database, so do you have any idea to solve this matter either in query or module? Please see carefully for this sample table:
Fields: Date / DE1 / DE2 / DE3 / DE4
15/03/2001 15 12 14 12.5
29/03/2001 30 25 28 26
15/04/2001 39 36 37 36
30/04/2001 45 43 44 44
so i need make comparison between BeginDate and EndDate for DE1 / DE2 / DE3 / DE4 this mean EndDate for DE1 compare with BeginDate for DE1 and so on.
If is possible please let me know, you assistance must me appreciated.
Best Regards,
Haj1503