Recent content by jg85120

thank you i know it was simple, i am not familiar with SQL so i did not know where to put it

Okay, one more quick question: can i get that to only display Failures to date for a specific Area ID say "Area ID = 3" only instead of all 7 thx

INCREDIBLE!!!! Dude, this thing has been killing me for days! More than likely I am going to post another question later today or tomorrow, hopefully it will be less confusing. I can not thank you enough.

The following Work Order Numbers are exactly what are in my database followed by their Date Entered dates: CC-01-10173-00 6/4/2001 CC-01-11778-99 7/9/2001 CC-01-90113-02 8/6/2001 CC-01-90113-16 8/6/2001 CC-01-90113-04 8/6/2001 CC-01-15200-00 9/7/2001 CC-01-15185-00 9/7/2001 I...

1 3 15 15 I ran that code ,and got the following with the example data i showed previously: Jun-2001 1 Jul-2001 3 Aug-2001 15 Sep-2001 15 I sadly cant offer any suggestions as I am totally new to this stuff (and barely understand your sql, lol) FAQ701-5268 had some interesting...

i am not sure what schema is, im guessing layout: ProductID Alpha-numeric Date Entered Date (6/2/2001) Date Closed Date AreaID Number 1-7 Work Order Number Alpha-numeric Work Order Notes TextMemo Bearings Checkbox Starter Checkbox Motor Checkbox Other Checkbox Not Sure Checkbox Ignore...

THX Just one problem, for example, there 3 work orders entered on 8/6/2001 so when it runs the query, the running total is multiplied by 3. If needed, i can post table and query.

My table is formated as follows: MTBF data: Date Entered Ranges from 6/1/2001 to present WorkOrderNotes Memo Data type Bearings Checkbox Starter Checkbox Motor Checkbox Other Checkbox My users goes through a form, read the Work Order Notes, and check all...