• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

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.
0
mmcgillo88
Asked:
mmcgillo88
1 Solution
 
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now