Recent content by SuperKoopa

Thanks for your replies! Example: Query Design Field: Acc_Num, Stat_Code, Cat_Code Table: Acc.Db, Acc.Db, AccStep.Db Table View - Table Name: Dual Stat Query Acc_Num, Stat_Code, Cat_Code 0012345678, 1, A1 0012345678, 5, A1 1123456789, 1, A1 2234567890, 5, A1 So in this example I would...

Hi Plog, Thank you very much! That seems to work just fine! One thing I forgot to mention however in my original post, but I need only the records where the Stat_Code = 1 AND 5. So for instance there are TWO Acc_Num Records for one acc value, one is for Stat_Code 1 and the other is for...

Hello! I am trying to create a query pulling from several tables. I will use the example below to illustrate what I'd like to do. I have a field called 'Acc_Num', one called 'Stat_Code', and a third called 'Cat_Code'. Each 'Acc_Num' can have multiple records because there are multiple...