You don't need to put brackets around the [a], but you should capitalize Access.

You have a table with 500+ records (the + implies "about").

If you really want the number of days left, then you would subtract today's date from [End Date], however there is no [End Date] in the list of fields you specified. Supposedly, it could be calculated from the [Period].

You need to learn how to be more consistent. Is it [Commence Date] or [Start Date]?

You probably want to use the DateDiff () functiion.

http://office.microsoft.com/en-001/acces...

Edit:

You could also use the DateAdd () function to add the [Period] to [Commence Date] to calculate an end date.

http://www.techonthenet.com/access/funct...

Edit: In order for me to test your query, I would have to create the table. You already have the table, so, instead of asking me if your query is OK, you should run it.

You seem to know enough to know how to figure this out.

Here is the update3