I have 3 subforms linked to 3 tables, they are driven by 3 seperate queries.
When I try to update them from the open master form with a command button, i
get the following error message:
'The database engine could not lock table <name> because it is already in

I have an Access table with a Yes/No field called Active.  If Active is True
for all records,
SELECT Active FROM ATHLETE ORDER BY Active;
Returns Active=True for all of the records as expected. However,

I have an issues with my Microsft Access Database.  It's an infentory
database, storing all the information about our hardware here at the store.
The files have been brought into the computers.  We have 11 computers in our
office.  Each computer has Microsoft Access 97, 200, XP, and ...

Hi all, I'm stuck trying to figure out how I can pull an employee's training
history for the current and prior year. The year is based on their hire date.
Then I need to archive everything older than 2 years. Any help would be
greatly appreciated. Thanks in advance.

I have designed a query where i want to sum how many quotes have been either
sent, not sent or rejected by country.
I have used this as my SQL but it brings up the number of overall records
for each country not the number of those sent or rejected etc.

How do I take two fields from two seprate tables and SUM them in a query?
[table1].[field1].what goes here[table2].[field2]
then put SUM in the total field? What would go between the two fields above
because I am not adding, subtracting etc

I have some queries that need to run on a regular basis to capture some
operating data.  Right now someone logs in and executes the queries on an
hourly basis.  Is there a way for me to set them up so they run automatically?

I have to select data where a renewal date falls in the next 90 days. Dateadd
would be perfect except the renewal date is given as MMDD.  When I run the
query with Oct, Nov, or Dec the recordset is blank.  Any ideas without using
a string if IIFs and/or cases in VBA?

I built the expression: IIF(IsNull([Rate])," ",[AmtBilled]/[Rate])
I still get #Error.  I want the field to either be left blank or a zero if
there is not a rate yet given or there will not be a rate.  Can you please
help me?

Is there any way to do several updates on a single column within one update
query?
For example"
update table set column1=1 where xyz='a', column1=2 where xyz='b', column1=3

I would like to have a cmd button open a continuous form based on a field
value on the current form.  I have a query already built that the continuous
form pulls from and I have a parameter set up in it to refer to the field in
question, but I still get a pop up asking for the input ...

I am using Four queries to get final percentage.
In first query I get all results from tables in particular date period.
In second query I get [Total] of result/Sample with respect to on
Field.

I tried to create a newtable from two tables by using "select statement".
However, a new table eliminated the duplicated value.
For example :
Table 1 : amount : 100

I have created a select querie, when I run it it has a box comes up that
askes me to type in the data to select, how can I turn that into a drop down
list to choose the data.
Regards

I have a text field that contains 2 or more words (Name,Lastname,Familyname)
The words are seperated by a space. How can i trim out the whole string from
the second space?
i.e.