I’m really stuck with this one. I have a field named Patient ID within this
field are numbers; unfortunately they are varied in length, from 4 digits up
to a maximum of 7 digits long.
My problem is: I need to make all of my Patient IDs 7 digits long, by

I have a Access table of names and addresses.  There is a postcode (zipcode)
text field.  I also have an excel spreadsheet with a single column of
postcodes; no duplicates.  
I need to get query to return each name and address in the table which has a

Good morning everybody
I'm using Access2003 on Windows XP SR2
I want to run a select query using parameters to query a table of placenames
and details.  All pretty straightforward.

I have some questions about delete queries.
I have two tables where data is input from a bound form.  I want
to be able to run a query whereby common data is written over
to a common table and the data in the two original tables is deleted.

I have a table with the following logical structure:
Name...Number eaten of apples......Number of eaten oranges.....All fruits
Mike...............3..............................
..........4...........................7

I created a query that has many calculations.  It all works fine until I
enter the criteria "<>0" in one of the calculated columns.  It then treats
the columns that are the addends in that equation as if they were parameter
queries.  In other words, it asks me to input values for ...

I have a query which runs off two sub-queries.I have tried to include them
as nested queries in the original but it hasn't worked.
Below is my revised query followed by the original and then the two sub
queries.

I have an access table that has account numbers ex 45208 (all are four
digits..  I want to change to account number to ex 4520.8   I need to break
up the accounts numbers with the period.   Is there a way to do this in a
query?  I have over a 100,000 rows of data to change.  Any ...

I am trying to import an excel spreadsheet into access and keep getting type
conversion errors.  The reason is because the first cell in some fields is a
numberic value while following cells are alphanumeric values.  Thus, acess
automatically defaults with a numeric data type, ...

Helo,
I have problem in report  !!!! I think it can be resolve by NZ Or Nul
Expression but I don't know how?
Problem is_

I'm building a query from several others, and I'm running into the
following problem:
Two of the queries, when added to the query, do not show any fields,
just an empty box with the query title at the top.  Is there some

I have a query with this criteria on a data field.  <= Date()-4383
I know it's restricting the date but can you explain the formula please?
Thanks,
Trentrongg

I wonder if anyone can help please.
Prices of products have an effective (valid from) date.
I.e. a 1kg of Rice cost £2 from 20/09/07;  £1.80 from the 25/09/07, etc.
I have two tables:

Our business uses Client Codes to identify clients and to derive Project
Codes.  The Client Code consists of the first three letters of the client's
last name, and the first three digits of the client's street address.  For
example, Richard Thompson, who lives at 1313 Mockingbird ...

I currently have a "Keyword" button on a form that runs the parameter query
below
Like "*" & [Enter Task Keyword] & "*"
A pop up appears where I can type in someting like Printer