Dlookup with Date Range

[pamela0813]

Ok, so I have this table (tblPayPeriod) with the fields Start Date, Stop Date, Pay Period & Percent FY. The Percent FY field is a Number field that gives off the percent of the fiscal year (FY) that we are in.


Then I have a report (rptDistrictMgr) that in the header I want it to display what percent of the fiscal year we are in based on the Auto_Date that is in the header.


So, if today's date is December 17, 2014, we are (according to tblPayPeriod) 24.1% into the fiscal year and I want the 24.1% to display in the text box which called Text99.


I don't want it calculated. I just want to look up the percentages that I have already listed in a table called tblPayPeriod.




Please help!

[pbaldy]

Does this get you started?

DLookup Usage Samples