Parameter coming up for expiry date

[FranCorona]

Good Morning. I have a query that brings up employee's license expiration dates.

I have following fields:
EmpName AACDate AACExpDate: DateAdd("yyyy",4,[EmpAACDate]) EmpStateLicExpDate NGLicExpDate: IIf([EmpStateLicExpDate]<[EmpAACExpDate],[EmpStateLicExpDate],[EmpAACExpDate])



The first query I did for just bringing up the expiration dates works fine, but when I created another query to bring up the actual license it asks for a parameter for the AACExpDate. I can't figure out why this is coming up.....when I click ok it runs the query with the correct info as far as I can see, but I would like to get rid of the parameter box. I tried with: EmpAACExpDate: [EmpAACDate]+1460 and that also brings up the parameter box. I have been searching through help topics both online as well as in Microsoft Help but can't figure it out. Thank you for any and all help with this.

[FranCorona]

I solved it. I just recreated the query from scratch and now it is working....don't know what was happening but oh well. LOL Everyone have a wonderful weekend!

[RuralGuy]

Thanks for sharing your success and solution with us.