I know this should be easy, but I can' t figure this one out to save
me.
I have two tables, linked by unique serial number.  I am pulling
date/time from one table and their process codes from the other.

I have received a text file where currency is indicated in a format called
overpunch characters. An example is "00000015{" (without the quotation marks)
which needs to translate to $1.50. The last character determines both the
last digit of the currency sequence as well as the ...

I'm just wondering why the Jet db engine can't use comments.  It should be a
simple task to add that token to the engine.  Most other db engines accept
some sort of comments.  Certainly ANSI SQL accepts them.  Even if it's some
Microsoft proprietary character to signify a comment ...

In my building inspection database, I've created a query, based on a single
table, that adds up the values for repair works (Capital Cost) at each site
and based on my expression, assigns an overall condition category for each
site.

I have a query that select the first 14 chars from the field. The field
data is something like the following
PGLV120060215-AT001
DLLCV220060310-AR002

My queries work fine up to a point but if I enter any more than 2 criteria it
seems to 'drop' one of them.
It means that I can't look for specific data.
Am currently using Micrsoft Access 2003.

Ths following query *actually runs OK* - until Access opens it in the Query
editor (opening it in either the Design or SQL views will break it with
subsequent attempts returning an "Invalid Bracketing" SQL syntax error).
SQL: SELECT KOSTL, NAME, SAP_PLANT_NO FROM (SELECT ...

I have built a search form that has three unbound controls. On is a text
control that the user can input the company name or contact and the other
two are date controls where the user can put in a date range. Here is the
sql

I have a table with various data, I need to make calculations of this data in
many ways. I currently have two queries that are doing a count of the data
shown below and I want to subtract one from the other for a seperate query
for a report. Any ideas?

I'm making a Cut list for a Department for materials based off a
Product ID. When I enter all my Product ID numbers into the Criteria I
want the materials for, if I have 2 Product ID's....Access groups them
into one ID when I run the Query.

Hi, I have set up a bunch of queries linked to a test data source. I now want
to change the data source to the live data source.
What are the steps that I need to follow in order to change the data source
(DSN)?

I have two tables - Transactions and Rates.
Table: Txns
Refce   TxnDate       Curr     Amount
10       21/03/2006    USD       10.87

I want to so something like
INSERT INTO MyTable IN [Enter the path to a database] SELECT * FROM MyTable
WHERE UserID = [Enter User ID]
I know the second parameter part is possible, but has anyone successfully

I export a file in on a monthly basis and use the information to create a
report.  The problem is that one of the fields the information is more than
27 characters and causes problems with the report if over.
The field contains titles, I created a new table that has the old titles ...

I've read through the threads and haven't found anything that has helped.  I
have a calculated column that I would like ranked.  It shows average
application production - here's the calculation that I use:  Round(Sum([Total
Life])/Count([ST_Code]),2).  Article ACC2000 didn't work ...