missing operator

[Greg Loriman]

Hi Folks,

Access is telling me that I'm missing an operator when I try the sql below.
The line it indicates is the first after the select (marked with a #).
Presumably the next two would suffer from the same problem.

I can't see what the problem is. Here's an example of the SQL :


select bk.BOOKING_DATE,
#cint(8dayBooking+9dayBooking+10dayBooking) as 8DaysBookings,
cint(9dayBooking+10dayBooking) as 9DaysBookings,
cint(10dayBooking) as 10DaysBookings
FROM [bookings] bk;

I've tried this with and without "Cint".

Anyone got any clues

Greg

Ps
The real query is here (the bad line is marked with a # again):

select uzo.BOOKING_DATE,uzo.BOOKING_TIME, format(uzo.BOOKING_DATE,"dddd") as
BookingDay, Cint(format(uzo.BOOKING_DATE,'ww')) as WeekNum,
Cint(0) as SlotUtilisation,Cint(0) as RoundCount, uzo.CC_7DayMember,
uzo.CC_5DayMember, uzo.CC_Other, uzo.CC_Corporate,
uzo.PB_Member,uzo.PB_GreenFee, uzo.PB_Society,
uzo.RT_ExMember,uzo.MTD_Platinum, Income, Income_Golf, Income_Food,
Income_Other,
Cint(0) as 10daysBookings,
Cint(0) as 9daysBookings,
Cint(0) as 8daysBookings,
Cint(0) as 7daysBookings,
Cint(0) as 6daysBookings,
Cint(0) as 5daysBookings,
Cint(0) as 4daysBookings,
Cint(0) as 3daysBookings,
Cint(0) as 2daysBookings,
Cint(0) as 1daysBookings,
Cint(0) as 0daysBookings
from [Utilisation Slots Amalgam - zRec only] uzo
UNION select unz.BOOKING_DATE,
unz.BOOKING_TIME,format(unz.BOOKING_DATE,"dddd") as WeekDay,
Cint(format(unz.BOOKING_DATE,'ww')) as WeekNum,
iif(unz.SumOfRoundCount>0,1,0) as SlotUtilisation,
unz.SumOfRoundCount as RoundCount,
iif(unz.CC_7DayMember>0,1,0),
iif(unz.CC_5DayMember>0,1,0),
iif(unz.CC_Other>0,1,0),
iif(unz.CC_Corporate>0,1,0),
iif(unz.PB_Member>0,1,0),
iif(unz.PB_GreenFee>0,1,0),
iif(unz.PB_Society>0,1,0),
iif(unz.RT_ExMember>0,1,0),
iif(unz.MTD_Platinum>0,1,0),
Income, Income_Golf, Income_Food, Income_Other,
#(0dayBooking+1dayBooking+2dayBooking+3dayBooking+4dayBooking+5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 0DaysBookings,
cint(1dayBooking+2dayBooking+3dayBooking+4dayBooking+5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 1DaysBookings,
cint(2dayBooking+3dayBooking+4dayBooking+5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 2DaysBookings,
cint(3dayBooking+4dayBooking+5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 3DaysBookings,
cint(4dayBooking+5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 4DaysBookings,
cint(5dayBooking+6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking)
as 5DaysBookings,
cint(6dayBooking+7dayBooking+8dayBooking+9dayBooking+10dayBooking) as
6DaysBookings,
cint(7dayBooking+8dayBooking+9dayBooking+10dayBooking) as 7DaysBookings,
cint(8dayBooking+9dayBooking+10dayBooking) as 8DaysBookings,
cint(9dayBooking+10dayBooking) as 9DaysBookings,
cint(10dayBooking) as 10DaysBookings
FROM [Utilisation Slots theoretical Amalgam (arrived) - no zRecs] unz;


--

 

[Greg Loriman]

In case anyone asks : I've checked the values I'm trying to add together and
they are numbers, so the addition should work.

Greg

 

[Greg Loriman]

I've worked it out. I needed square brakets around the fields names I was
referring to.

Greg

 

[John Vinson]

I needed square brakets around the fields names I was
referring to.

Yep. Or, don't start fieldnames with digits.

John W. Vinson[MVP]