Recent content by Windsor302

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.