Solved

Writing a query in Microsoft Access 2007

Posted on 2012-04-06
2
290 Views
Last Modified: 2012-04-09
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
Comment
Question by:mmcgillo88
2 Comments
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
Comment Utility
try this


Select [Invoice Type], Department, Count(LineItemAdjustment)
From tblInvoicesSubmitted
Group By [Invoice Type], Department
0
 

Author Closing Comment

by:mmcgillo88
Comment Utility
Great, quick response!
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now