I'm trying to sequence claims in a table.  Claims can have any number of
service lines, so the claim number is not unique.  I want the claims labled
Claim 1, Claim 2 and so on for each customer number.  I have ordered the
table by customer number and then claim number and tried ...

I need to create a report from a table that collects the time that a
manufactured item is ready for delivery.  One item I need to add to the
report is the time differential of each manufactured item sent to a specific
location.  For example, Widget 1 has a ID of 1, and production ...

I have a crosstab query in which my columns, based on [BidType], give totals
based on the field LineTotalSellPrice.  It returns the totals properly with
the expression:
LineTotalSellPrice: Sum(([Quantity]*([UnitPrice]+[QuoteCost]))*[Markup])

I am using Access 2000.  The following query puts the records into the table
AL EXPORT in the same order as they exist in AL EXPORT SORT.  The records are
created somewhat randomly and put into AL EXPORT SORT.  It appears like the
ORDER BY clause is not being used at all.  Why?  ...

I am pulling data into access and the date time field is stored as a text
field in this format, 200705031200.  How do I do a date diff between 2 dates
stored as text?  Can I convert them?  Or.... ?
Thanks,

I have a tables with around 1000000 rows and 30 field colums.I need to
delete rows that have NULL value in specific field.Can anyone help me in
this???

I have a crosstab query with product line as my row heading and date as my
column heading and am tracking monthly sales. How can I populate the cells in
the crosstab query that have no values with zeros.
Thanks.

I have a field named [SubdLot].   Many of the 32000 records look something
like "The Sands - lot 16".   I obviouly need to pull out everything from
"lot" and beyond and drop it into [LotNo] field (not all fields have a
hyphen... there are numerous variations!!)  

I have field [inv_no and is numbered from 1 to 999999. I would like the
numbers to be from 000001 to 999999 (all fields with six numbers). Any
suggestions? Thanks.

I have follow steps by steps instructions under the "Use Parameters in
queries and reports" to create a parameter collector so that the query table
will display the stock name which i selected.
But the macro seems like does not link the form and the query.

I'm new to the Access database query language & need some help regarding
"null values" & converting them into another record within the Access
database. The question & background is:-
I have extracted some payroll data from another database (excel) & have

From a list of 100,000 contacts, how would I select 1,000 records randomly?  
The purpose of this is to mail out solicitations to various records from
different sections of the database instead of sequential selection.  
Sequential selection would extract records from only one or ...

Is there a way in which i can determine the difference in date between the
date stored in a field and the end date of a query request?
example:
Field has date of 1/1/07.  Query asks for a date range.  Date range given is

i have a table tblPayee/Payor...with fields PID, Rate, Name...there are about
200 PIDs, with their corrseponding rates...these rates are subject to change..
. what i want to do is that every last day of the month, i would like to
compute for the individual accrued balances ....id ...

I have a field called CONTACT that has both a name and phone number as
text.
I need to separate this into two fields, NAME and PHONE.  How do I
display just the name?  Since the string is of variable length, how do