Hi, I need to concatenate a field, and sum another field, grouping the
first field.
Acct  legalDescrip      acres
77    Parcel-1Text        10

I know this maybe very simple, but I can't seem to get my formulat to work.  
I need to remove the leading apostrophe in a numeric field from a text file.  
When I use the replace function I get an "ERROR# in fields without data.
How can i strip away the apostrophe from these ...

I have a query that produces 1000's of rows of data and I need to create
several smaller queries by indicating specific criteria.  The first criteria
will be the "month" and this changes everytime I run the query.  Then the
rows need to match 2 different field names.  This is ...

I am using access 2003, All data can be read-only.  
I have a main unbound form with one combo box, and 4 bound subforms.  The
record source for the subforms are pass through queries.  
I can't follow normal procedure and link the subforms to the combo box, I

How do you calculcate a percentage of another field in a query?
Thanks.

Our company has two databases, one for international customers and one
for US customers.  These two table contain the same fields but
seperate data (see below).  Is there any way I can creat a query to
show me all the records?  Is this possible

My Db records my daily work activities according to the various projects to
which I am assigned. For the purpose of reporting back to my supervisor, I'm
building a series of queries that will display only those records that cover
specific periods of time. The use of a parameter ...

I have been trying to create a query in Access, that divides three numbers
For Example:  1/.165/203650. and have been unsuccessful in matching the
output to match what I get in either Excel, or in windows Calc beyond the  
12th decimal place. Is this rounding error?

crosstabs in Access 2002 seem to have a limit for the length of column
headers: 20 characters. Queries with headers that differ only after the first
20 characters do not work.
Any suggestions to get it work? Is there, e.g., any registry parameter that

How can I get a value for [c?] without creating a circular reference? In the
below example, I have just but it down as coming from Table1, but in fact it
should be [Table1].[c]/tb.[Total%] from Table1 LEFT JOIN Table1 AS tb ON
[Table1].[cn]=tb.[cn] AND [Table1].[a]=tb.([a]+1)

I use access as a members area login. When the username and password are
entered correctly the results form displays a link in to the index login
page.
My question is , is it possible to also have the login recorded in another

Page code creates a string of all ManufacturerPartNumbers that share a common
ProductFamilyID based on a ManufacturerPartNumber form selection. This string
is then included in the recordset query.
The following error message only occurs when the ManufacturerPartNumber

I am enquiring is it possible to add a picture to each line in a table.Some
may be blank and some may have pictures on it.
The table is run as a search form and that is up and running though i am
trying to add pictures of people to go with there

I have a query that uses this lookup:
Expr1:
DLookUp("Timer_Elapsed","QRY_Run_Reveal_Timings","Run_waypoint_List_ID = " &
[Run_waypoint_List_ID])

I have the following query:
SELECT tblNominals.NomCode AS Code, tblNominals.NomName AS Name,
Sum(qryIdNominals.Nett) AS Balance
FROM qryIdNominals RIGHT JOIN tblNominals ON qryIdNominals.NomID =