Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
count help
I'm assuming you would like to get a result for the PTotal and one for the FTotal. So, take Expr1 and break it into to expressions like this: Expr1: Sum(Abs(([1-Work Order /Kan Ban Card Present]="P")+([2-PIR at machine / Line]="P")+([3-PIR filled out per schedule]="P")+([4-SPC Chart data...- Doogles
- Post #10
- Forum: Microsoft: Access Queries and JET SQL
-
count help
It depends on what "count" you're trying to get. Is it (for example): 1) the number of P's in all 11 fields of 1 record, or 2) the number of P's in 1 field of all the records, or 3) the number of P's in all 11 fields of all the records Here's a solution for each: 1) SELECT Person...- Doogles
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
get maximum value only
Here's another possibility for you. It's very similar to Lothario's suggestion: select t1.part_id, t1.part_name, t1.part_date from yourtable t1 WHERE t1.part_date = ( Select max(t2.part_date) from yourtable t2 Where t2.part_id = t1.part_id ) Hope this helps!- Doogles
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
