Using Access 2003:
Fuquay Varina NC 27526
Raleigh NC 27611-5458
Zebulon NC 27597

I have a crosstab query which looks like such.
Column  Jan  Feb  Mar  April and thru dec.....
Row 1     15   0      34    0    
Row 2     9     10    0    23

I get an error when I try to run the following
INSERT INTO tbl_Round2
SELECT *
FROM tbl_Changes_PSG_Round2, tbl_Changes_IPG_Round2;

I am looking for a way to do the following.  I have a QUERY with data that
looks like the following:
Employee      Salary      Reimbursement      Code
1229              500.00          

I've been asked to come up with a report and I'm having difficulty with
my limited Access skills in trying to construct the Access query
that'll get me what they want. I'm hoping someone can help me out
here...

I want to create a new table, based on another table, with a boolean field
defaulted to "No". But when I use
NewField: CBool(No)
in my MakeTable query, Access creates a Numeric field instead of a Boolean

Okay, I'm not sure if this is possible but I have a database that is being
used company wide.  Each one of my forms that might need additional action I
have a field for "Next Action Required By:".  What would be the simplest way
to create a query to search these fields in each ...

I hope someone can help. I am trying to use the FixedAddress function in one
of my queries as follows:
   'NewAddress: FixedAddress([address1],[postcode])'.
However I keep getting an error message stating that the expression is typed

Working with access 2003, consider myself an intermediate user, but no (very
limited) programming skills.
I haven't attempted this on my own yet, as I thought I'd write it in first
to see if I'm on track.

Can someone tell me why I'm getting this error in my append query:
"MS access set 'x' fields ot null due to a type conversion failure, and it
didn't add 0 records to the table due to key violations, 0 records due to
lock violations and 0 records due to validation rule violations.  ...

When I am writing an append query for a database with several relationships,
80,000+ records, and many required fields, I don't want to get a message back
saying "Cannot append 76000 records to the database due to key violations"
especially when the query looks reasonable.

I have a table with a start date, start time, end date, end time, a
numeric points field, several event description fields  which are
yes/no, and a participants field that is populated with ID number(s)    
ex.  122, 158, 247, 266, 275

I have an ASCII file that I import daily and I need help in avoiding the
Comma Deliminated issue I run into.
If a user inputs a quote in the description my import will generate an error
and not import the data correctly.

How do I send a picture (illustration) to someone on my list without
forwarding it?  Also, how do I send someone a message to someone else
without revealing other recepients?
Thanks

I have a list of 50 names (A) and a list of 550 names (B).
I want to use the names in list A to filter/query list B.
List B contains address, contact and map info, list A is
a weekly delivery schedule.