I have put together a little demo of what I've been trying to show you. It
is a DB file with 3 parts.
Payments Table
Payee

I would like to know if there's a way to get a running total for a field in a
query like ytd total:[item1]+[item2] that will reset to zero in 2006.

Hi.  I have a query that I need to modify and I can't get the syntax correct.
I have members that have 1 or 2 mailing addresses.  To determine which
address to use, I have AddressFlag which equals 1 or 2.  The query I have is
working correctly, but now I need to add Country into ...

I'm trying to compare a value in an array and assign the value a numeric
score.  For some reason, my query is returning no records, but I can use
similar code in other places and it works.  See the SQL below.  Any help
would be appreciated.

I have a database to manage and track document control numbers and maintain a
master document list.  I have created an append query for adding new
documents to the master list.  The query will assign a new number to the
document and create a new record for the document in the ...

I have a table as follows:
OrderID(AutoIncPriKey), CustID(ForeignKey), Order Description
I want to know the query that would limit this table's data to the last
Entered Order for each CustID

I have a half dozen date fields for tracking various stages of a job, and
need to report which records were updated in the last week, and ONLY the
most recent entry for that report.
tblJobStatus - fields included for report:

I have many parameter queries that work great.  However, is there a way to
construct a parameter query so you can input multiple selections.  For
example, one query prompts for Item#, you enter it and the records return
just fine.  However, is there a way to enter 2, 3, or 4, ...

This is my second time posting this request.
I wasn't sure if it went threw.
I have the following fields in a query.
PayeeNum

I am trying to have a running total by Dist, By Month By Year.  I can Not
figure it out.  Please help  Thanks
SELECT WebCharts.Dist, DatePart("m",[RTL_Date]) AS [Month],
DatePart("yyyy",[RTL_Date]) AS [Year], Count(WebCharts.key) AS ProjCount

I want to generate multiple records from a single record such that the sum of
each of the multiple records equals a value in the single record. I.e. I have
a record that states that I need to manufacture 100 units of product x. I
wish to create 25 production orders each to ...

for example  i have a phone number field and an 800 phone number field
phone                   800 phone                expression
800-571-1234        800-571-1234           800-571-1234
717-234-5678        800-231-1234    

I have a table in an access databasse that has three fields.  Is there a qry
that can count the number of characters within a field?  Thanks.

I have a Query [CAL_RESULTADO] with some columns... [_DIA] & [CODIGO
CLIENTE] and some more. In [_DIA] you will find diferent dates:
31/10/2005. Some of these cells of [_DIA] can be empty.
What I need is to check in [_DIA] to find a specific DATE and in case

Hi All,
I have a table with the following attributes:
Customer_Code, Product_Code, Category, Month, Value
Where "Category" has the domain BudgetTurnover and ActualTurnover