It seems as though there have been some changes made to queries in some
of the database that I use regularly for reporting. I have queries that
are using other queries and it seems as though someone has gone in and
changed the sub query names to one that don't exist but are similar ...

I am trying to save changes I made to a query, however each time I try I get
the following error message:
"The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time."

Summary:
1.  I want to define a column in an MS Access table to be a lookup on
another
table.

I have to pull data for display from a database that has a table with more
than 255 columns.  The problem is that the data I need is beyond the 255th
column.  Anyone know how to do this?
Thanks

I have a complex query that serves as a basis for joining to a table whose
fields need to be updated with values from fields in the complex query.
Trying to run the update query results in the "Query must use updateable
query" message.

If I have two tables, A and B,  with unique IDs in table A and
duplicate matching IDs in table B, how do I write a query to pull out
only one of the matching IDs in table B?   Assume that the ID is the
key field in both tables.  For example, in Table A, I have  an ID =

I am trying to create a query which displays mothly invoicing based on
a selection from a combo box on a form. So for example if I pick May
from my combobox, I would like everyhting that was invoiced in May to
appear in my query. At the moment I have inserted MSCAL.Calendar.7 to

How do I take the dates that are different in the Effective Date field (see
bottom two dates) and incert them in the field named Start date. I know this
is redundant data but the tables have a lot more data to them and they have
been manually  entered. So I must locate, sort ...

I am trying to figure out what are the differences between a query in
SQL and Access.
I am having problems with my Access query.
Which one should I use?

Hi there - and many thanks for reading (and helping hopefully...)
I have some reference data regarding what sorts of offers can be given out
during sales calls that looks like this:
Campaign   Offer_No

I have two tables with identical fields  (i.e. ID, OtherHerb1,
OtherHerb2, OtherHerb3, OtherHerb4). In one table there are 744
records. In the other there are 651 records. Some are complete in one
and some are complete in the other. But, there is no consistency in the

OK.  I need to be more specific. I alway try to be short and sweet so as not
to bore anyone.  The last replier I am sure gave great info, but it was hard
to follow along since I was unspecific.
I am a manufacturer of 11 products sold to a large chain store.

Would someone be so kind as to put up instructions on calculating time.  
Basically looking for:  Field2 subtracted from Field1 and output Field3.  
Should this be in a query?  Thanks in advance.

I have created a query in Access containing some Text fields with large text
values.
If I export the results to Excel using File/Export... the large text fileds
are truncated to 255 characters in the resulting excel cells.

I'm joining two tables together in a Form as a Datasheet View, but I'm
stuck on a query that won't return all records.  Here are my 2 tables:
customers (Table 1):
- customer_id (auto number, PK)