Writing a query in Microsoft Access 2007

I have a table, named tblInvoicesSubmitted : Table, and I need to pull a few columns from the original data into a query. I want to look at a column named "Invoice Type" and a column named "Department" and need to group those together by counting another column "LineItemAdjustment" (I need it to count if there is a value there). Please let me know if you need me to clarify.
mmcgillo88Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try this


Select [Invoice Type], Department, Count(LineItemAdjustment)
From tblInvoicesSubmitted
Group By [Invoice Type], Department
0
 
mmcgillo88Author Commented:
Great, quick response!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.