[Apologies for an apparent cross posting -- I accidentally posted this
to .forms instead of .queries and I'm now posting correctly]
One of the great failings of the past 20 years of Microsoft's
dominance has been the failure to implement good file system

Pertaining to Access XP (2002):
I've noticed that when you run a make-table query it does two annoying
things that have the potential to cause problems.
One is, it sets the "Subdatasheet Name" property to [Auto].  I've read that

g am new to Access and working on a request tracking database that will be
used by multiple users (6) throughout the day.  The users would like to run
several basic queries that display the requests that they have input into the
database for the day.  Can the users run the ...

If I want to do an expression in a query that depicts data for a month how do
I do that? I do not want to have to put in a year because that will be
determined by what date is selected on the form and then that information
will print on the report. Let me further explain.

I have corss tab query which returns the sum of "retail_units" columns
based on the dates written in PIVOT FORMAT line in below written
query.  these dates are basically the parameter which i am generating
at runtime by running vba code.  all these columns are mandatory for

I have 3 columns (taxable_ac, zone, levy) in a table named "temp".
I would like to update levy with taxable_ac*10 where zone=1 and
taxable_ac*20 where zone=2. I would prefer to avoid using multiple imbedded
if-statements if at all possible. Here is where I got stuck.

I have a name field that looks like, John Doe.  I would like to split this
field into last name and first name fields.  Can someone tell me how I would
do this?
Thanks.

I have an MS Access Table that I use to store log information and it
looks something like this:
tblLog
ID    Job    SN    Message    Date

I'm trying to create a query that pulls the top total amount paid
based on a combo box in a form such as 11%. where do I put the form
name and combo box in the SQL statement.
SELECT TOP 35 PERCENT Query1.[Cust ID], Sum(Query1.[Total Amount

I need to find the rows that exist in one table but not in the other
with this condition:
(prod_name exist in table1 and not in table2.prod_name ) AND
(prod_name exist in table1 and not in table2.'S'+prod_name )

I have a table that I have created and I want to have one field auto
populated with information from another table based on two other fields in
the first table.
I.E.  Table One - Super Office and Office would pull the Admin Code from

hii i have a question in my mind that i want someone to solve that i tried
alot and thought of it alot . the question is that how to get the ten or less
or more lower values in the querry as we get top values in querry. thanks in
advance.

I have a field in a crosstab query designated in design view as follows:
Account Name:AccountName where AccountName is a field in one of the tables
used in the query.
There is another field inthe query which contains an If then statement based

Table 1 has 1 field and 20 records (unique tracking nos.).  Table 2 has 8
fields and 900+ records.  Field 7 of Table 2 contains the unique tracking
nos. -- 20 of which are found in and comprise Table 1.  I want to do a query
that will pull only the records from Table 2 (with all ...

Using a patrameter query, I want to query two tables. For instance, lookup
the name "Smith" in each tabel in the field [last name]. Neither table has a
primary key Do I need ajunction table and if so how do I create it.