see,if this was sql server,then  it was easy.
Since it is msaccess.Then i dunno.
Don't know how to declare variable in msaccess,query window and use it.

Any way you can also this in front end.
Proceed then ask.