Cant export query to csv

J

Jason

Hi,
Query below is producing "expected" result but when I try to export result
to a csv file, the export option in file menu is disabled, at the same time
if I dont use format in the date part export is fine. The date has to be
formated to be used in updating another database to be precise a mysql
database

[query]
SELECT ENTRANTS.EN_SEASON, Format(RACES.[RC_DATE],"yyyy-mm-dd") AS
RACE_DATE, ENTRANTS.EN_RACEINSEASON, INDS_1.IN_FULLNAME &
IIf(IsNull(INDS_1.IN_CLAIM) Or Val(INDS_1.IN_CLAIM)=0,""," (" &
INDS_1.IN_CLAIM & ")") AS RIDER, ENTRANTS.EN_RIDER_ID, ENTRANTS.EN_SADDLENO,
([HO_NAME]) AS HORSE, ENTRANTS.EN_HORSE_ID, INDS_2.IN_FULLNAME AS TRAINER,
ENTRANTS.EN_TRAINER_ID, ENTRANTS.EN_WEIGHTCARRIED, IIf([EN_HOODED],'H','') AS
HOODED, ENTRANTS.EN_DRAWNO, INDS_3.IN_FULLNAME AS OWNER,
ENTRANTS.EN_OWNER_ID, ENTRANTS.EN_COLOUR AS RacingColors,
HORSES.HO_BREEDER_ID, INDS.IN_FULLNAME AS BREEDER, RACES.RC_EVENTNOINMEETING,
RACES.RC_SCHEDULEDTIME, RACES.RC_DISTANCE, "Distance " & [RC_DISTANCE] & "m"
AS DISTANCE, RACES.RC_NAMELINE1, RACES.RC_NAMELINE2, RACES.RC_TYPE,
[RC_PRIZE_1]+[RC_PRIZE_2]+[RC_PRIZE_3]+[RC_PRIZE_4]+[RC_PRIZE_5] AS
GrossStake, RACES.RC_PRIZE_1, RACES.RC_PRIZE_2, RACES.RC_PRIZE_3,
RACES.RC_PRIZE_4, RACES.RC_PRIZE_5, RACES.RC_PRIZE_B, RACES.RC_SEASON,
ENTRANTS.EN_COMMENTARY, RACES.RC_ISJACKPOT, RACES.RC_ISJACKPOT4,
RACES.RC_ISPLACEPOT, INDS_1.IN_RIDER
FROM (HORSES LEFT JOIN INDS ON HORSES.HO_BREEDER_ID = INDS.IN_INDIV_ID)
RIGHT JOIN (INDS AS INDS_1 RIGHT JOIN (RACES RIGHT JOIN ((ENTRANTS LEFT JOIN
INDS AS INDS_2 ON ENTRANTS.EN_TRAINER_ID = INDS_2.IN_INDIV_ID) LEFT JOIN INDS
AS INDS_3 ON ENTRANTS.EN_OWNER_ID = INDS_3.IN_INDIV_ID) ON (RACES.RC_SEASON =
ENTRANTS.EN_SEASON) AND (RACES.RC_RACENOINSEASON = ENTRANTS.EN_RACEINSEASON))
ON INDS_1.IN_INDIV_ID = ENTRANTS.EN_RIDER_ID) ON HORSES.HO_HORSE_ID =
ENTRANTS.EN_HORSE_ID
WHERE (((ENTRANTS.EN_SADDLENO) Is Not Null))
ORDER BY ENTRANTS.EN_SEASON DESC , ENTRANTS.EN_RACEINSEASON DESC;
[/query]

How do I go about this??
 
Top