I am a novice Access user. I am unable to get the answer from DLookup that I am expecting. Question: I just need to find out the minimum wage in effect at a specific payroll date. I am trying to extract minimum wage rate data from a table (tblMinimumWage) that has 3 columns (MinWageID, Date, MinWage). The data in the minimum wage table is daily. I have records for minimum wage for each day for the last 30 years. I created a query pulled down a field from another table which shows payroll date as "DatePd". The table "tblMinimumWage" is not a table in my query. My formula in the field section of the query is MinWageRate: DLookUp("MinWage","tblMinimumWage","DatePd"). "DatePd" refers back to a field in the current query. My problems are either an error message stating MS Access can't find the field in my criteria "DatePd" or it returns the first record in the "MinWage" field which is incorrect also. It appears I have a problem with the criteria section. I hope all my ramblings make sense. Thanks in advance for your assistance.