Alter Table method

I have create this querydef to add a table:

Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text"
qdf.Execute

I don't want to add the column as the very last column. I thought that the correct syntax was something like

Set qdf.SQL = "ALTER TABLE Employees ADD COLUMN Department Text BEFORE Birthdate"

to add the column "Department" before the column "Birthdate" but that doesn't work. can someone remind me of the correct syntax? I know it is possible I just can't remember or find in my SQL books.

Thanks

Andrew