I have a simple table that has two columns  surname and firstname,
how do I combine the results into a third column?
Good at Excel but very new to Access.
Thanks.

Can I link an individual table cell in Word to a unique value in an access
table or query that automatically updates the word doc if the table/query
changes?

The databse is for tracking educational expenses at a medical practice
each emplyee is given a budget.
I have a form that contains employee demographic data inlcuding their budget
and remainder value. It contains a sub form with a list of Educational

I have two fields on a form:  one a "check box"  and another a "combo list"
If the check box = Yes, then I want the field for the combo list to require
data.  I can make it go the field that I want the date inserted, but I cannot
seem to figure out how to make it mandatory for the ...

How can I setup a query to pull year to date budget info? I have a table (tbl
budget) that contains budget information by project. I have "month" as a
field name so each project is enter 12 times in the table (1 for each month).
I will need to obtain year to date budget info ...

I have a form called "View Hood" that contains a textbox and subform, called
"Units subform" in datasheet view.
I would like the subform to automatically update with selected records as
the user types in a search criteria.

Using Access 2002 and would like to enter data into form which will then send
to fields in multiple tables and update them.
Can this be done and how
need basic explanation

I am trying to run append queries to join 8 tables.  I was able to run the
query one time, however, each time after I receive the following message:
"Invaid Argument"
All of my tables are identical...any help would be great!

I probably have a misunderstanding of the use of a ADO Recordset.
I thought a Recourdset is a view and if I change it without updating
the underlying table (data) wouldn't change. But what I was
experiencing was different.

We have a few access databases that when opened say they are the "Access
2000 file format". Most of the users are using Office 2003 and maybe 1 or 2
with Office XP. I would like to install Office 2007 on my system. I am the
one that goes in and makes changes to the databases when ...

I have 6 tables that have the same data types in them. It is 6 levels
of information, but for each level the data collected is the same. So
for instance, in the tblMainGoals i have GoalID, GoalNumber and
GoalName. Then in the tblLevel2Goals I have Level2ID, Level2Number and

I have header and details forms, let say frmInvoiceMain and frmInvoiceDetail
In header form , I have field User Modified and Date Modified.
In details form (frmInvoiceDetails), I have code like below :
Private Sub Form_AfterUpdate()

I'm currently using Access 2002 Sp3 and I'm having troubles with
importing data from a text file. The text file is 750Mb in size.
Are there any handy tips or tricks that I ould using tryiong to import
this data.

Is there any way to have Outlook prompt you with a "Do you want to proceed"
type message if you are sending to a distro list?
 The reason I ask is because we use distro lists all the time at my
company, and it would be quite possible to get a few different letters wrong,