I have a table with fields: Task Name, Revision Number, Effective Date,
Descr, etc
So it looks something like:
Record 1: "Task A",1, 1/1/08,"abc"

Hope this is the right newgroup...
For some multilingual application, I have a table with all strings in
different languages. Each entry has a reference, a language and a text
value, e.g.:

I have a field that contains batch numbers.  Apparently, they were created a
while back and I've been told they are Cobol numbers.  However, they give
problems in our system because they contain symbols like !, $, & etc.  
I have to mark all the ones with symbols in them as "Do ...

I have a 'fair' amount of experience with access, very little with SQL
Here's my challenge:
I want to enter in a StartDate and EndDate for an order, Say 01-jul-06
and 31-dec-06 in a table (with a form, or not). I would like new

I have a report in my database that has been working perfectly for months.  
No changes have been made to the report or the queries it is based on.  Today
when I try to run the report, I get a "too complex to be evaluated" error.  
The SQL of the query behind the report is

I have a query where I'm trying to rename a field if it meets certain
criteria.  Example:
IIf([Group]In("A", "B", "C"), "Atlanta", IIF([Group]In("D", "E", "F"),
"East", IIf([Group]In ("G", "H", "I"), "North", "West")))

How do I delete a record in a query ?  It's time consuming looking for the
record in the table to delete.  I want it to delete off the query and the
table.

I need a query that shows me all records both assigned and unassigned.  
The unassigned would simply just have empty fields.
SELECT AssignedBatches.StartDate, MasterBatch.BatchNumber
FROM MasterBatch LEFT JOIN AssignedBatches ON MasterBatch.BatchNum =

I'm having trouble creating a local table in the current database. I'm trying
to use a SQL pass through query. Could you look at this and tell me what I'm
doing wrong?
CREATE TABLE ActiveEmplyeeAnnualRate (last_name, first_name, annual_rt)

I am using the wizard to place a button on a form.
ON CLICK I would like the following to happen :
1. Open a report (x) in view mode - upon closing
2. Open a form (y) in edit mode - upon closing

I imported data from an Excel spreadsheet into an Access Temporary Table so
that I can import that data into a Parent table and then a Child table.
The import to the Parent table was successful.
Now I need to import data to the Child table and still have referential

I have a Microsft Access database with all the research capabilities of
professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search

I have a query that references 4 tables with the same format data in them
(ie. deliveries from 4 locations - 1 per table) with fields Item, Quantity,
Delivery Date.  Each table can contain the same item or different ones.  I
need a query to return a total list of unique Items ...

Can I use MOD 60 in a querie I have Stopdate and Startdate and trying to get
my  TotalTime to have   Hours and Minutes. I acn get Hours  but when I use
Mod 60 it doe not work when I test the querie. This is what I'm using in the
field

Can anyone suggest a query to tackle the following problem?
MIXTABLE
ID    MIXID        DESCRIPTION        LAST_MOD_BY
1    rec1        recipe1            rich