I'm finding in Access 2003 SP2 that, when I do a left outer join, a
calculated field in the right query is propagated to all records in
the outer join, not just those in common with the right table.
Here is the setup:

I have a real-estate database.  The Main Form contains all the detail
of a specific property (e.g.Address, Size, Status, Value).  I have a
subform that counts each type of size within a certain block, and
groups them by size, status, and value. (ex: Fifty 2-bedroom units

Okay I am going bald pulling my hair out. I have tried the below two options
and neither result works.
If company = C1 then display WDNVL and etc.
What am I doing wrong?

I am getting #Error in VAL field when I do very simple query based on
qryKS3 query:
SELECT *
FROM qryKS3

Any insight appreciated.
I have 2 tables, both containing a "task to do" field.  
The first table is a listing of all "tasks to do" defining what tasks are to
be done by people who work in a specific job position. (each person has one

Created a Microsoft Access query in MA 2002 SP2 which connects to
various tables in a very large Oracle database (5,000 tables).  Access
is used for ad hoc reporting purposes.
When we upgraded from running Win98 to Windows XP Professional (ver

I have a table with 6 columns: ID, Name, Date1, Date2, Date3, Date4
Each of the date fields is a different date, and they are not in
chronological order...that is, Date1 could be earlier or later that
Date2 and so on.

I have a table
Name    CodeQuestion     Mark
....         ...........             .....
I want insert 1 column index autonumber by query please help me!

I am using Access 2000. When I run a query, I would like it to prompt me for
a date range and pull only those records.

I have the following statement in a query.
8HRTWA:
CDbl(Nz([RESULT]*[TIME_MINUTES]/IIf([TIME_MINUTES]<=15,15,IIf([LIMIT_TYPE]
In ("TLV","PEL") And [TIME_MINUTES]>15,480,IIf([LIMIT_TYPE]="REL" And

I have a table which has a field called "Time Period". In these fields,
there are a bunch of months ie. January, February etc.
How can I sort it so that when I create a combo box that pulls up
distinct Time Period values, it shows up as "January, February, April,

I have a table.  The table has a little over 200 fields.  About half of these
fields are filled from check boxes on a form returning a value of 1, 2, or 3
(Representing statuses of ok, uh-oh, and oh my God!). I need to make a query
that returns all the records where any field ...

I am importing information in from another database that has a text field
with the following (815)555-1212, how can I remove everything via a query but
the numbers so it reads 8155551212?

I have a table which has a field called "Time Period". In these fields,
there are a bunch of months ie. January, February etc.
How can I sort it so that when I create a combo box that pulls up
distinct Time Period values, it shows up as "January, February, April,

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.  
When I use this Parementer [Search Name] in my query, I put in ABB, I'm not