Access Query to SQL keeps bombing out

[lloydanderson]

Hello all;

Very new to SQL and Access. We are attempting to move a Access query to SQL and the following works in Access but not in SQL - The query "against a view"

[MTD CG Occ Rm Budget]+[MTD SG Occ Rm Budget]+[MTD WG Occ Rm Budget]+[MTD GG Occ Rm Budget]+[MTD EG Occ Rm Budget]+[MTD MG Occ Rm Budget]+[MTD CV Occ Rm Budget]+[MTD CI Occ Rm Budget]+[MTD PC Occ Rm Budget]+[MTD LI Occ Rm Budget]+[MTD EI Occ Rm Budget]+[MTD MI Occ Rm Budget]+[MTD WI Occ Rm Budget]+[MTD GI Occ Rm Budget] AS [MTD Total Occ Rooms Budget],

We then use the AS [MTD Total Occ Rooms Budget] results in the query such as;
[MTD GG Occ Rm Budget]/[MTD Total Occ Rooms Budget] AS [MTD GG Mix Budget],

How should I be doing this? your help will be appreciated.