Bigsteve42
Technical User
Sorry this is a bit complex to explain. I have the following tables.
TbltNtype = [Nttype],[ntdesc],[ntclass]
TblNsubt =[nstype],[nsubt],[nsdesc]
TblNAct = [naact],[natype],[nasub],[nadesc]
TblNtran = [ntact],[ntdebit],[ntcredit]
The type,subtype and ac fields of the subordinate tables match those of preceeding tables. what I am trying to do is run a query that totals the amount for each type/subtype and includes the ac,subtype desc and ntclass. My current query gives me everything except subtype description but when I use the subtype table and include the desc field I get multiple entries that shouldn't be there. I'm going blind trying to figure this out and would really appreciate someones help.
Thanks
TbltNtype = [Nttype],[ntdesc],[ntclass]
TblNsubt =[nstype],[nsubt],[nsdesc]
TblNAct = [naact],[natype],[nasub],[nadesc]
TblNtran = [ntact],[ntdebit],[ntcredit]
The type,subtype and ac fields of the subordinate tables match those of preceeding tables. what I am trying to do is run a query that totals the amount for each type/subtype and includes the ac,subtype desc and ntclass. My current query gives me everything except subtype description but when I use the subtype table and include the desc field I get multiple entries that shouldn't be there. I'm going blind trying to figure this out and would really appreciate someones help.
Thanks
