Solved

Writing a query in Microsoft Access 2007

Posted on 2012-04-06
2
298 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 37817685
try this


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

Author Closing Comment

by:mmcgillo88
ID: 37823161
Great, quick response!
0

Featured Post

Create Professional Looking Email Signatures

Create "Professional HTML Email Signatures" with ease.
7 Day Money Back Guarantee if not 100% Satisfied.
Affordable - Try it out for 7 Days Totally Risk Free.
Installers provided for over 45 Email clients.
Both Windows & MAC Supported.
Highly Recommended!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
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 create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

734 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