I'm having difficulty achieving a result I'm wanting in a query....  I'm not
use to having problems with queries but this has been my week for them!  :)
I have a table that has Month Booked, 1st Pmt Date Long, and Last Pmt Date
Long.  I have multiple months (Month Booked) inside ...

I have a query that looks like this:
TRANSFORM mytable.var1,Count(mytable.var2) AS cnt
SELECT mytable.var1,  count(mytable.var2) AS TOTAL
FROM mytable

I think this should be fairly easy but I can't seem to wrap my brain around
it today!!
I am linked to a table that provides an EXTREMELY basic audit trail for work
tasks.  Unfortunatly, for me, I cannot modify the table in any way.

First- I am not an advanced Access user. That said, can someone please
explain how I can export a query into Excel.
Thanks,

I have a query with the field name "LastName". When I pull a report and
export it to excel at the top of the column it come out as "LastName". How
can I change it in the query so when I export to excel the column heading
says "Customer/Entity Name?

I am trying to calculate percentages in a query based off a total number.  
There are two fields Country (Text Field) Individuals (Number Field)
This is what it curerntly looks like.
Country Individuals

I am designing a query that joins two tables by SSN.  I need to identify
missing records from one of the tables.  Table1 has 279 records in it.  
Table2 has 3221 records in it.  Table2 has two additional fields that I use
in the query to set the criteria.  I want to see ALL the ...

I have the following string: 00737 013 33 02665 stored within my table as a
single field. I want to write a query which parses the string into the first
5 characters which would be 00737, the 11th and 12th character which would be
33. Is there a way to write a SQL statement which ...

Is there a way in a pivot table to calculate percentages of catagories based
on the total record?

Is there a way I can format the cells in the table? I would like to have
some red or blue numbers?
Thanks
Chi Huynh

i have a database that is pretty large and everything is based off a site
location.
i am running a query where i have users first name, last name, email address
and site location. but some of the users are at multiple sites.

I need to update multiple fields in my table and one field needs to be
updated twice, that is, I need to remove the first character (an ') and also
insert an hyphen.  The updates run fine separately, but I don't know how to
update the same field twice in one query.  Do I need to ...

I have a query, where it will ask for the current year and the previous year
dates. Once this is processed it will produce my query as follows:
CurDate: is the month of Sept
PrevDate: is the month of Aug

I've imported 2 tables from Excel.
Each has the same number of records.
Each table has 1 field, unrelated to other table.
Is there a way to join the 2 tables into one table that has 2 fields, using

I know people have asked this before but please help an ancient ignoramous.
I have a pass through query to return records that match a date.  This works
fine when the date is hard written in the SQL.
I need a method to change the hard written date in the SQL to one selected