J
Jasonm
Is there a way to implicitly set the data type of a new filed in a make
table query? My sql is below, and I need the to set several of the fileds to
single or double, but they are being created as long integer...
What do I need to do to get this to funciton? I have searched several NG's
with no success and have not found the answer in the help file.
Thanks in advance, Jason
SELECT Equipment.ID, Equipment.CategoryID, Equipment.HourReading,
Max(Hours.Hours) AS MaxOfHours, 0 AS NewHours, Equipment.Description, Date()
AS NewDate INTO tblHoursEntryPS
FROM Equipment LEFT JOIN Hours ON Equipment.ID = Hours.EquipmentID
GROUP BY Equipment.ID, Equipment.CategoryID, Equipment.HourReading, 0,
Equipment.Description, Date()
HAVING (((Equipment.CategoryID)=7) AND ((Equipment.HourReading)=True));
MaxOfHours comes in as a double because Hours.Hours is a couble, but
NewHours starts out as a long integer and I need it to be a Double... Thanks
again for your help
table query? My sql is below, and I need the to set several of the fileds to
single or double, but they are being created as long integer...
What do I need to do to get this to funciton? I have searched several NG's
with no success and have not found the answer in the help file.
Thanks in advance, Jason
SELECT Equipment.ID, Equipment.CategoryID, Equipment.HourReading,
Max(Hours.Hours) AS MaxOfHours, 0 AS NewHours, Equipment.Description, Date()
AS NewDate INTO tblHoursEntryPS
FROM Equipment LEFT JOIN Hours ON Equipment.ID = Hours.EquipmentID
GROUP BY Equipment.ID, Equipment.CategoryID, Equipment.HourReading, 0,
Equipment.Description, Date()
HAVING (((Equipment.CategoryID)=7) AND ((Equipment.HourReading)=True));
MaxOfHours comes in as a double because Hours.Hours is a couble, but
NewHours starts out as a long integer and I need it to be a Double... Thanks
again for your help