Search results

Hey guys, here is the code i am working with so far: SELECT [TRO SCOPE 3].WELDER_ID, Count([TRO SCOPE 3].WELD_DATE) AS WeldsCompletedtoDate, Count([TRO SCOPE 3].RT_DATE) AS RTCompletedtoDate FROM [TRO SCOPE 3] GROUP BY [TRO SCOPE 3].WELDER_ID HAVING ((([TRO SCOPE 3].WELDER_ID) Is Not Null) AND...

thanks, I have three queries built from each other to get the one that i use, could i apply this to the last query? would i put: where [weld_date] = #date# and #date# from table [scope 3] thanks again

Hey guys, I am trying to rename a table. In the navigation pane it shows up with the correct name but when i open the table the tab on the top still shows the old name and when i try to print the old name shows up. Any idea how to fix this issue, thanks!

hey, here is the columns that pertain to this query.. thanks

this code gives me a missing operator for the dates? what is missing, thanks. SELECT Count([SCOPE 3-COUNT].Weld_No) AS WeldCompleted, Count([SCOPE 3-COUNT].VT_No) AS VTCompleted, Count([SCOPE 3-COUNT].RT_No) AS RTCompleted, Count([SCOPE 3-COUNT].MT_No) AS MTCompleted FROM [SCOPE 3-COUNT]...

would i make this query from the percentages query or the step before? thanks

perfect, thanks

I actually have a question about this query, is there a way to set it between specific dates, for example i need to print out a report every 10 days of the previous 10 days only

Hey guys, how do I remove or change the color of the underline that is present under the column headings in my report. Thanks.

it worked out great, i was trying to do it all in one query, there was a third step to get it to percentages which all worked out great, thanks again. I posted a new thread with my other issue in the query forum if you wouldnt mind taking a look, thanks

It wont let me, this info is using features...blah...blah

Hey guys, I am first going to explain what I am trying to achieve then tell you what I have, Tasks are performed by multiple People, overall 20% of each Persons Tasks has to be tested. However the Tests have Categories (qualifier 1 and 2, original, repair, rework etc..) and the first 2...

I got it to work, thanks again, I have another question about a different query if you dont mind?

Thanks, the second (group query) is a seperate query right?

should i send you a few rows from my database?

Hey there, I need to count 4 different totals. Using 4 categories and only unique values. I was wondering if I could do all 4 in one query. Thanks

actually, maybe it will be easier this way, there are several categories along with the qualifiers, the only ones that will be taken for percentages are original and rework

#2, each workers first 2 tested pieces are not counted towards the overall percentage needed but are still considered completed tasks

Hey there, I need to include in my report a text box that counts dates. There will be multiple entries of each particular date but it only needs to be counted once. What formula would I enter. Thank you.

hey there, so i have started entering data into this table, there is a new criteria that needs to be included in the percentage query, each MT_No/Date is assigned a type (qualifier 1, qualifier 2, original, repair ect...) the first 2 (qualifiers) do not count towards the percentages, how could i...