Search results

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...

help please...

from looking more into it... it also doesn't add correctly or show all the fields...

i dono if this will work... never done it... http://www.filejumbo.com/Download/B22077746FA736CA - i forgot to show the database window so you will need to download... make a new database and import the table and query but what i did was made another database with just the information...

it works on both there^^^

SELECT EnterJobLabor.Rate, Sum(EnterJobLabor.HoursWorked) AS SumOfHoursWorked, EnterJobLabor.DateWorked FROM EnterJobLabor GROUP BY EnterJobLabor.Rate, EnterJobLabor.DateWorked HAVING (((EnterJobLabor.DateWorked)=([dateworked]-Weekday([dateworked])+7))) ORDER BY EnterJobLabor.DateWorked; i...

hmm... yeah... 1, 1.5, and 2

no... it doesn't

i thought it looked oka... but i know for a fact that there should be a rate of 1 for each week just like there is a 1.5 but the 1 isn't showing....

Oh... here SELECT EnterJobLabor.Classification, EnterJobLabor.Rate, EnterJobLabor.Shift, Sum(EnterJobLabor.HoursWorked) AS SumOfHoursWorked, EnterJobLabor.DateWorked FROM EnterJobLabor GROUP BY EnterJobLabor.Classification, EnterJobLabor.Rate, EnterJobLabor.Shift, EnterJobLabor.DateWorked...

shift should be a 1 or a 2 - that works class is jw,ad,pm,op,ef... etc. - that works rate should be 1, 1.5 or 2 - doesn't work

i showed a picture.. does it work?

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...

Thanks... i got it to work with this... TRANSFORM Sum([Chart Abs T].[Sum Of From]) AS [SumOfTerms] SELECT ([ft Date]-Weekday([ft Date])+7) AS Expr1 FROM [Chart Abs T] GROUP BY (Year([FT Date])*CLng(54)+DatePart("ww",[FT Date],0)-1), ([ft Date]-Weekday([ft Date])+7) PIVOT [Chart Abs...

this is my chart as of now... i want to change the week number to a date

TRANSFORM Sum([Chart Abs T].[SumOfSum Of From]) AS SumOfTerms SELECT (Format([FT Date],"ww"" '""yy")) AS Expr1 FROM [Chart Abs T] GROUP BY (Year([FT Date])*CLng(54)+weekday([FT Date],vbmonday)+1), (Format([FT Date],"ww"" '""yy")) PIVOT [Chart Abs T].clientid; like this? i'm new to all of this...

TRANSFORM Sum([Chart Abs T].[SumOfSum Of From]) AS SumOfTerms SELECT (Format([FT Date],"ww"" '""yy")) AS Expr1 FROM [Chart Abs T] GROUP BY (Year([FT Date])*CLng(54)+DatePart("ww",[FT Date],0)-1), (Format([FT Date],"ww"" '""yy")) PIVOT [Chart Abs T].clientid; this is what it looks like in sql...

can you help?

i tried... i cant get it to work correctly... i can change it to show daily but i need it to group by week still jus to show the date not the week number