I need to get the total of one field based on another field in a query. In
other words sum one field by grouping on another. Is this done by count, sum
or? and where and how do I group while trying to total by another field? I
will also need to sum by an expression while grouping ...

i want to create a query below...
every time i run the query, Access pops up a messagebox asking for the
"table_name" from which records are selected...
select * from table_name;

I have [AmountPaid] in a totals query.  Of course, it is stripping out the
decimal and 00 cents
(25.00 is changing to 25)
I know how to make it "look" right using

I have a database that I am working on.  The data is coming from an AS400
into Access 2003.  I have "4" Queries built on 2 TABLES. Each QUERY builds on
the previous one.
I have several $$ fields in this QUERY related to payroll dollars

I have the following query:
SELECT CustID, ProdID, Sum(Amt) AS Prem
FROM tbl_dta_DivYearTran
GROUP BY CustID, ProdID

I created a Query and in the price column I mutiplied it by 1.08 which gave
me a decimal along with the number. I want to drop the decimals but not have
it round up or down.

I have the follwing Query: "Event Type Q1"
SELECT [Event Type].EventTypeID, [Event Type].EntryTypeCategory,
[EventType].EventTypeDescription
FROM [Event Type]

Hi All, I searched for some help on this but could not find exactly what I
was looking for.
I have a Text box on my form for NATURES OF DISTRESS, and in it, I have
about 20 different options, derived from a lookup to another table.  

I've seen all the answers to the transposing questions, but mine is a little
different. I actually want to do the reverse, I would like to take the row
data and convert to columns:
Currently:

Hi, please could someone out there who knows what they are talking about help
me - I am reaching the end of the road both in terms of my own sanity and in
the avenues of inquiry that I can go down. I am working with Dreamweaver 8
and Microsoft Access 2003 - when I try to insert a ...

Greetings!  Need a little orientation.  Have a Data table with a series of
event dates and associated counts on each date.  Would like to create a
fixed list of weeks (I set the starting and ending weeks) with counts per
week.  Appears that one needed element is to create a Calendar ...

I am currently upsizing an MS Access db to a sql server db as part of a
project to put a system on the net. To understand the logic of the current
program it would be most helpful to identify which queries are run in what
order. For example, on a search button, what queries are ...

I am looking for advice on how to complete an action in the context of an
Append Query.
My database stores financial information for customers on a year-to-year
basis.  Each customer has a unique id, and when combined with the calendar

I have an append query that is dropping an entire field.  It says it has "set
to null due to a type conversion."  The query has 4 fields in it that match
the table names.  The four fields are all number fields in the tables they
come from that are lookup fields that return a text ...

I have a table named product that looks like this;
fields:     key    prod   result
records   1      800     pass    
                2      800     fail