How can I update on an address list "Po address" name to read P.O. with out
changing the rest of the address.  I just want to change the "Po to read
"P.O."?  Any help will be greatly appreciated.  Thank you.

Help.................
I have a probelm with seperate Access databases merging when PDA's are
sync'd back to handbase.
I have created a a handbase database created with Data Exchange to get

I have tried, but can't get the syntax right - I have a db that tracks filing
due dates, and I want to run an action query that affects the DueDate field.
If the "filed" field (Yes/No datatype) is checked (true), then I want to set
the "filed" field to false, and make the DueDate 20 ...

In AXP I have a crosstab query which is throwing up a syntax error for the
line below.
PARAMETERS [forms]![frm_WhereSeen_Groupdata]![txtWhereSeen] Text ( 255 ),
Between [forms]![frm_WhereSeen_GroupData]![StartDate] And

Within a query, I created a column based on a fairly complex calculation
referencing a number of fields in the database and a number of fields in the
form that uses the query (this query is behind a ListBox on that form).
I've given the "created" column a name (let's call it XYZ) ...

I have a table containing in excess of 100 000 records. I am running a query
with a calculated field to determine the age of members from a DOB field.
Everything works fine, however, the DOB field is text, allowing for captured
errors, in turn resulting in #error as a result for ...

I have one field of data that I search by for all of my queries called
project.  I have created a query called machine types that lists all of the
projects and I created a list box from the machine type query.  I have
several queries that produce different subsets of the data.   ...

I want to create a query that will alow a user to search only one drug or
more drugs depending on user's needs. For instance, a user can see activity
for only asprin or he can see activity for asprin and zantac.
select drug, username, date

I've posted about something similar some time ago and got a response telling
me to use a union query, but I've never got it to work.... Anyone got any
more advice?
I've got 2 tables with a 1-many relationship as follows:

Hello, in table1 I have a field: tel1
That field has telephone numbers entered. I want the number "0" entered
right after the 4th number of every entry. For example, if 123456789 is
entered, I want it to become 1234056789. So 0 (zero) is entered after the 4th

Have 100+ queries that want to copy into 100+ .mdb files (in Access 2003).
However, seems unable to select more than one query at a time for copying
(the usual: CTRL A, or Shift Click, or CTRL click do not work).

I just upgraded to Office 2007 and in one of my database's, when I try to
open my queries in design view, I get this message: "is not a valid name.
Make sure that it does not include invalid characters or punctuation and that
it is not too long.

Hi is it possible that we can give Column Number as a parameter to select
Records at Runtime in access table .
eg, Table having structure like this, Where Qtr1..Qtr4 Stores Amt Paid by
customer,

I need to amend a query but when I do it becomes un-updateable, so need to
find a solution whereby I can update and add new records etc.
The issue is as follows:-
I have a frmWorkShops which lists the main details of each event, and a

I have a form that "builds" an SQL statement depending on the selections on
the form. Everything works fine except for the last part of the statement
where a date criteria is set. The SQL statement, when executed, should return
records with a "QueueDate" <= 11/10/2004 but for ...