I have a 2 field query created and want to create a third field with a
calculation/expression. One field is the company name and the other field has
the sales total for each invoice. There are multiple entries in the company
name field for the same company. (ex company A has 5 ...

Hi. I'm triyng to build a criteria the load the values from a table.
Imagine that in my table I have the colum Codes, and I have 3 records in
that table.
the records values are 3; 10; 15

I am creating a tenant database and would like to create a query where I
charge each tenant monthly rent. I have a table that lists the tenant info
including the rent amount and a table that reflects each transaction linked
to the tenant table. How do I use a query (append?) to ...

G'day All,
I have to create a report which shows how many qualifications were
awarded to students in a given year. A qualification is deemed to be
awarded to a student if the student has achieved a passing grade for

I am running some queries using a form I created and for some strange reason
some people are falling off and coming back to the report when I run the
queries and then re-run them immidiately after.  I am not changing any of my
parameters and the data is not changing in the tables ...

In a crosstab query that has the column heading set to customer name
with a where clause a parametrised date range and sums the total
orders. This is then used as a sub query in another standard query and
there is only a few customers.

Hi. I have this decimal value: 0,104239055 wich means 02:30:06.
Once I have to sum severel decimal times, the sum of the seconds are
transformed into minutos. but that in my case is not important.
Image if I sum ten times 0,104239055 I final result would be 25:01:03 but I

I am new to access. I need to link to an external database. With the
external database changing information daily I assume just to link to the
database. How do I refresh the data from these tables daily.
Thanks for your help--

I have a query that has a built expression in it (first name + last name =
fullname).  How do I change this expression to say (first name or spouse name
+ last name = fullname) ?  I have tried editing it but it doesn't seem to
work.

I have two querries that are being joined by student IDs;  some of the
querries have middle itintials and some middle name...  IF we have First and
last exactly the same but one middle is A and one is Ann -- I get 2 different
entires.

I have student lists from 2 sessions.  I need to pull out all students
registered for both sessions.  They have student ID in common.
I need to create another querry that will match sem1table.studentID and
sem2table.studentID  ...

When I create a Parameter [Category?], I want to be able to look up specific
category data. When the Parameter window pops up and I put in the
information, I get this error.
"This expression is typed incorrectly, or it is too complex to be evaluated.

I have multiple Regions that contain Districts with sales dollars in both.
In a query I would like to sumarize to one line for each region and district
for sales dollars . Also can you explain how "where"(aggregate function) is
used in totals.

maybe somebody can help me with my problem; im new in this field  S O
R R Y
_________________________________________________________________________________
code___/__Description____________/___OrderQty_/__OrderIssue/

I have a query that picks up various pieces of data from tblEstimate. One of
these fields is EstimateNo
I have another table called tblInvoiceNumbers, there are only two fields in
tblInvoiceNumbers - EstimateNo and InvoiceNo, all fields described are number