I am new to access and am trying to create a query that joins the first and
last name in a table to create a new field called fullname that has the first
and last name together.  How do I do this?

I have two functions that separate a "first name" field, called FName,
consisting of either just a first name (Melanie), a first name and middle
initial (Melanie J), or a first name and middle name (Melanie Jean), into two
separate first name and middle name columns.  The two ...

I have a Access 2003 database file listing all licensed hunters & fisherman
(purchased from Fish&Game in my home state), about 200,000 names. From
another source I have imported a Voter File list of 45,000 registered voters
names.

Is it possible to created a calculated field in a query which would be the
running sum of another field?
I have created a text box on a report to have the running sum and now need a
similar effect on a form. I have a subform and each detail line contains a

I am using 2 Cross-Tab queries to denormalize data to present in a datasheet
view within a subform.
I've added a YES/NO field to the underlying query, which the user wants in
order to SELECT/DESELECT one or more records using this YES/NO field.

Hi,
I am currently running a query off a table in Access.  I have a calculated
field in the query which looks at the results of another column from within
the table.  

Hi to anyone that can help
I have a form with a subform, within subform there is a field that has a
value called subtotal for each row in the subform.
Is there a way for me to add up all the values in the field for all the rows

My system tells me I need a required update for office, but it keeps failing.
I have checked into numerous suggestions and no luck. It had 3 month trial
which is not expired yet, but is still telling me it is a required update. It
keeps failing.

I have a query to list the top two scores for a competitor but get three or
more results where there are multiple instances of the same score

Hi to anyone that can help me
This is a new query I have to one I had earlier but now need to do something
else and cant get it to work.
I have a subform that uses a query that lists in its columns the stockno and

(Reformulated question based on an earlier post. Thanks to Duane
Hookom's hints!)
I have a query (qryActDay) that sorts activities by weekdays (Mon, ...,
Sun). Each weekday is either void or contains the first activity

i need the help in one query.
Problem is - Let there are 70 'Towns' and each town has fixed number of
'Sites'.e.g 'A' has 10 'Sites','B' has 12 Sites ,'C' has 15 Sites and
so on.In every Town water sampling is done.Say from Town 'A' out of

I hope this is the right place to ask this question.....
I currently have a Macro that uses the RunApp option.  The app that is run is
simply the command "c:\copyfile.bat"
It's a bat file that Prompts the user to enter a file name....then copies

I am very new at this and can't seem to figure something out. I am using the
common formula for calculating ages. ( I added it as a calculated field in my
query and I have a DOB field so I thought it would work.)
DateDiff("yyyy",[DOB],Date())+(Format([DOB],"mmdd")>Format(Date() ...

I have created an address table that I would like to use in a form via a
drop down that would show all address fields.  How can I make my selection
show all the detail for each record instad of only the first field (name)?
Name