[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • 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

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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