|
|
 |
| found 1 articles for 0.303 sec |
  |
| Hey, I answered my own question.
UNION QUERY
SELECT [Job List].Year AS [YEAR], [Job List].[Job Name] AS JOBNAME,
ACTIVITY.DATE AS [DATE], ACTIVITY.JOBNUMBER AS JOBNUMBER,
Choose(Left([jobnumber],1),"KWA","Panara
Bread","MGDF","","WJA","","CITTA/HOTZ","MISC.","MISC.") AS GNAME, "EC"
AS TYPE, ACTIVITY.HOURS AS ECHOURS,0 AS CDHOURS
FROM ([Job List] INNER JOIN ACTIVITY ON [Job List] |
|
 |
|
 |
Group: microsoft.public.access.queries · Group Profile · Search for Cdhour in microsoft.public.access.queries
Author: Foocat
Date: Jan 27, 2007 12:26
|
| Show full article (2.06Kb) · Show article thread |
|
|
|
|
