W
Wayne-I-M
Hi
I have a need to produce reports in Italian and English from a query
(I know you "could" use up to 7 IF's - but trying to see if there is a
better way)
eg.
I have a table - tblTrips
with a field [tripDayOut] (date)
I have created a simple table with the name of the week in English and Italian
tblDayTranslate
DayNumber 1, 2, 3, etc
DayUK Sunday, Monday, Tuesday,etc
DayItaia Domenica, Lunedì, Martedì, etc
I have tried a really simple UNION (which is not working) like this
SELECT Weekday([TripDayOut]) AS txtTransDay,
FROM tblTrips;
UNION SELECT tblDayTranslate.DayUK
FROM tblDayTranslate;
Maybe it's not possible to use a calculated coluumn like
Weekday([TripDayOut])
as the join.
Any ideas on how to link these two unrelated tables so I can get
Weekday([TripDayOut]) = the Italian name of the day
Thanks for any tips you can give.
I have a need to produce reports in Italian and English from a query
(I know you "could" use up to 7 IF's - but trying to see if there is a
better way)
eg.
I have a table - tblTrips
with a field [tripDayOut] (date)
I have created a simple table with the name of the week in English and Italian
tblDayTranslate
DayNumber 1, 2, 3, etc
DayUK Sunday, Monday, Tuesday,etc
DayItaia Domenica, Lunedì, Martedì, etc
I have tried a really simple UNION (which is not working) like this
SELECT Weekday([TripDayOut]) AS txtTransDay,
FROM tblTrips;
UNION SELECT tblDayTranslate.DayUK
FROM tblDayTranslate;
Maybe it's not possible to use a calculated coluumn like
Weekday([TripDayOut])
as the join.
Any ideas on how to link these two unrelated tables so I can get
Weekday([TripDayOut]) = the Italian name of the day
Thanks for any tips you can give.