Hi,. I'm a student trying to turn in my final exam.
Can't figure out how to use an Update Query in design to remove extra
letters (fff or ggg) from a column(or field).
any suggestions ?

I have a table to store customers' names and I need a
query to retrieve the names and to have them counted.
In a report one can do that with running sum property of a
field. Is it possible in a query?

I have a production db for tracking quality control issues:
ProdTable has field DateProd, which is the date products are produced.
QCTable has ProdID (unique number assigned to every item produced), DefectID
(number assigned to particular defect descriptions), and Quantity (which ...

I have built a database where users for mailing groups are identified by the
appropriate button on the entry form.  I then built a seperate table which
holds the details of the groups so that they can be picked out using a combo
on a selection form ready for label printing.

its probably very simple, but here goes:
I have a table VAN, a query VANQ and a form VANF.  When the user starts the
database, query VANQ is automatically run, the rresults of which address
table VAN and the relevant data from the table (that where the category is

I have a nested if I am having problems with.  If Cartage rate is 0 see 1st
part of below.  (I copy and pasted each part from below so can understand
better)
Round(IIf([CartageRate]=0,Round([FuelperRate]*[GrossWeight],2),

Can I create a view by using the 'Queries' ?
I got an error 'Syntax error in CREATE TABLE statement' in the following
statement:
create view viewCompanyName([Company Name]) as

How can i do this:
tbl Patients: PatKey(pk); PatientNo; PatientName
tblCharges: ChrgKey(pk); PatKey(fk); ChrgDate
tblServices: ServsKey(pk); ChrgKey(fk), PatientFee; InsuranceFee

In the query design, "group by" is set to "sum" or "avg". However, the query
run does not perform the arithmetic function. The result is a table that
changes only the header from amount to sumamount, but lists all the original
data.

I would have thought that this query would be very, very simple to
create, but I'm having problems. I want to return the very last dated
PTC of each item. As you can see below, I get EVERY entry of Item, not
just the maximum dated one.  So, I don't want to see the Item 106

There are 100 numerical entries for each day of a month. The fields are date,
time, and amount. How can the entries be added for each individual day of the
month in one query run?

Is it possible to select/retrieve data within access 2002 from a sql database
(.dba) i think

if i define some depended(crosstab) queriese in code, "query12
query13", then i want to set the form's record source is query13, ho
to do that?
i code as, but not work

I need to find all the students who have not registered for a Fall 2005 couse
that were registered in either Fall 2004 or Spring 2005.
So far I have made a make table for all the students registered for Fall 04
and/or Spring 05.  I've also made a make table for all the students

When I try run the following query I get an overflow error -
SELECT DateConvPt2.MonthYear, LocRef.LocCode, RevItem.RevItem,
SlitSales.Width, RollLengthCalc.NormLength, Sum(SlitSales.[#Cheeses]) AS
[SumOf#Cheeses]