Search results

trying to run a query to generate previous CO Sum values. Wrote the query below to do this and it doesn't work... please check it out and let me know what I did wrong. SELECT Sum(IIf([forms]![Main sub co Fm].[combo27]=1,0,[value $])) AS [Previous CO] FROM [Sub CO All Q] WHERE ((([Sub CO All...

What i am trying to do is group the raceways and have one row for each raceway... do this by grouping the packages and seperating them by ", " is this possible in a query or do i have to use a module? so i want it to look like this Raceway Package 1EECBX01 1APC-01, 1BMC-01, 1CCC-01...

What i am trying to do is group the raceways and have one row for each raceway... do this by grouping the packages and seperating them by ", " is this possible in a query or do i have to use a module? so i want it to look like this Raceway Package 1EECBX01 1APC-01, 1BMC-01, 1CCC-01...

i have a query i am working on that is sorted, sumed and grouped... i have it grouped by 4 fields (date, class, rate, shift) with one sumed field (hours). it doesn't group and sum the data correctly. here is the SQL SELECT EnterJobLabor.Classification, EnterJobLabor.Rate...

oka i have this chart... as you can see (in the blue area) i have the same date popping up... i cant seem to figure out why its doing it... here is the row source for the chart SELECT ([pulled Date]-Weekday([pulled Date])+7),Sum([Length]) AS [SumOfLength] FROM [Chart Abs 4] GROUP BY...

making a chart amount on the Y axis and date by week on the X axis... when i do this the date shows up as the week number instead of date (34 '07 for example) can i change this to a date instead?