Search results

That would be great, thans.

Thanks. So we are not able to make the values apear in numerical order then.

This is not the Primary key

That does not seem to be doign anything SELECT DISTINCT HOTBIT.[WELD_No], HOTBIT.[WELD_DATE], HOTBIT.[RT_ACCEPT], HOTBIT.[RT_REJECT] FROM HOTBIT ORDER BY HOTBIT.[WELD_NO]

Here is the code: SELECT DISTINCT TABLE.[JOB_No], TABLE.[COMPLETED_DATE], TABLE.[ACCEPT], TABLE.[REJECT] FROM TABLE; Where would i put the: ORDER BY NumberColumn (DESC) Thanks.

Hey guys, I would like a filter that when I sort ascending, will put the values in order(1,2,3..) be it in a table or query. Thanks!

wont that show the total of all and not individual sizes? unless im doing something wrong. Thanks

I have 6", 36" and 42" pipe that is welded together. I want to show the total of welds completed per size between certain dates. I have a query that seperates it out by individual date but i just want a total between a range of dates. Thanks.

Thanks for the input, I am summing because when i tried counting it just counted every box checked or not.

Hey guys, I need to calculate the percentage of rejected. I have a column for accept and one for reject. I want it to count when true in accept and reject, when i try this it shows up as a negative value? Any idea what i doing wrong? Thanks.

Got it! Thanks for your help, the syntax I used is: <Now()+30 And >Now()

hmm, not sure it is still taking dates from all over, it has almost cut the list in half though

Oh, no problem. Thanks for your help and theres no rush.

hmm, I am getting dates within 30 days, but also from a year ago? not sure whats going on

in the criteria I have entered =Date()+30, when I run the query it is blank.

Hey guys, I have a table for qualifications, there is a column with expiry date. I was wondering what criteria to use in a query that would show only those qualifications expiring within 30 days. Thanks a lot.

Hey guys, I am having trouble with my report. For 1 the gridline thickness is inconsistent, the sides are thicker then the top and bottom. Also, I am trying to get the grid to look like one you would find in excel but there is a gap between the top and bottom of every row. If you know hoe to fix...

Hey there, I am trying to make a query that utilizes check boxes. My code looks like this: SELECT DISTINCT [TRO SCOPE 3].Weld_No, [TRO SCOPE 3].VT_No, [TRO SCOPE 3].VT_Accept, [TRO SCOPE 3].VT_Reject, [TRO SCOPE 3].VT_Repair FROM [TRO SCOPE 3]; VT_Accept, Reject and Repair are all check...

Sorry, Weld_No, VT_No and Weld_Date are all columns in TRO SCOPE 3, i need to cound the "Distinct" welds and VT's completed between certain dates. Does that help? Thanks again.

This query is derived from and existing query counting the weldscompleted etc, from Table [TRO SCOPE 3], in this query i am trying to get the weldscompleted between specific dates. Maybe I need a seperate query for this? Thanks.