What are best ways to display an external excel file inside the ms access
form.

I need to the total sum of emploies i differents companies
Select [company], Sum([employment]) as (not sure what to write here)
FROM [mulitple locations]
Group By [company];

I am trying to populate a form using variables. I want the form to open with
all the records from the table displayed. A couple of the fields I am using
as variables are integers and I am unable to get the table to populate when
it is opened if these variables are null. I can ...

I'm not sure if I should be in this group, or Reports, but I'll start here.
I have a user who would like to do a count of unique records and display the
information in a query, or a report. Here are the basics:
She has a list of donors, some of the donors donate more than once to ...

I have a database detailing patients visits. In each visit I take patient's
photos, so each patient has many records for the same visit.
I created a query using the "unique values" property that outputs only one
record per patient's visit:

Need some help quick if possible.  I have several Spreadsheet's comming my
way.  Please don't ask, but there is going to be one for each client at
approx. 400 total.  Anyway, I'm thinking of pulling all into access.  Reason
is I need to run a count  on those clients with a number ...

I have a database with 3 tables that need to be part of a query. TABLE
1 has company id and process id fields. These two fields are used to
find records in TABLE 2 which is the process table. This is a one to
many relationship.

I have a database to track awards for our program. I have created several
queries and reports however I want to do a all inclusive status report for
the Awards program.
I have made Queries for Pending Awards for the Current Week, Previous Week,

I have a column, Members, where sometimes there can be multiple names.  I
pull a query and then run a report.  However, the data entered is all on one
line but I want the report to have it appear as a list.  For example, the
data in the table appears as Jane Doe - Spring 07 and John ...

I need help to calculate the employees pay rate history. I have two tables,
one included Name, WorkHours, and WorkDate, other table included Name,
DateNewSal, PayRate. For example:
Table One:

hey all,
i would like to link a PolicyNumber field concatenated w a field called
INVSUB to a PolicyNumber field in another table. can i do that or do i have
to create another field and update it to [PolicyNumber] & [INVSUB]?

I m newbie to sql. I use Access interface alot. I wanted to display last 8
days of data on crosstab query. However, the column headers are missing if
the data is not available. My query is here:
TRANSFORM Count([Closed Remedy PQR].[PQR Number]) AS [CountOfPQR Number]

I have a query from a couple of tables that includes ItemNumber, QtySold,
and SalesPrice.  I want to find all instances where a client bought more that
24 of an item and to calculate a 10 percent discount.  The discount is only
on the first 24 of items sold unless it reaches 48, ...

If I have missed the answer to this in an existing post, I apologize.  
Nothing matched.
I have Query Criteria for a customer field that is:
Like "*HOEFT*"

I am getting an overflow error when performing some calcuations  in a query
that I an  running.  Any idea how to isolate why this is happening?
Thanks,
Chuck