Can  anyone help a newbie .... I have to produce a list of films
currently available for loan. Members can borrow films, only one at a
time though. When a film has been borrow, a tick is put against that
member's field. Also, the details are stored in table 2. I need to be

I need to know if it is possible to send an email to users from access, based
on the results of a query.  The query will list the user and when there last
update to a table was.  Then it will send a automatic email to the users if
they have not accessed the table in a certain amount ...

I would like to be able to have my pivot chart print on more than one page.
I have a usage information for classroom for each year 2003 - present.
Classrooms are CR001 - CR057
So

My form (datasheet view) has 2 combo boxes. The value picked in ComboA
changes the values that are permitted in ComboB. The RowSource of ComboB is
Q_ClassPick (which of course uses a CombA value). When I first enter the
form, I can choose any row and the comboB values will be ...

Here's the IIf statement that's giving me trouble:
        CCur(IIf([QryBSum-SSum]![ShareVariance]=0,[VarWComm],"N/A"))
If I take the CCur out as shown below I get the N/A where I want it, but
it's not formatted as currency:

I need to make a query, that takes a part number, lists
all of the reciepts against it, and the date
received,looks at the quantity on hand and tells me the
age (todays date less the received date) of the inventory

Hi. I have 2 queries that are nearly identical.
Contacts (MemberOption=1) certify with Animals using NatlCertResults.
Contact (MemberOption<>1) certify with Animals using RegREADResults.
I am trying to create a form (display not entry) that is based on 2 queries.

I want to perform a query on my database where I want to select the returns
of all shares for a certain period that have a rating at a specific month. So
far I have the following query:
SELECT kr_oper.FUNDNAME, kr_star_l.month, kr_star_l.rating,

Hi, I have a database that contains nested queries and I import these queries.
That is, the database contains queries that have queries as data source
(don't mean to dumb it down, just want the situation to be explicitly clear).
In the top query the source queries are joined on ...

Good morning.
I am writing a query that uses selected data from two tables.  The results
then go into a summary report.  We want to remove the duplicated data.  I
tried the 'hide" feature in the report but it does not work for summary

I have a query that I am trying to pull all the records from a state field
based on user input.  I know using [] can get me one state but if I try
entering data such as "fl","GA" it comes up blank.  I have also tried
In([Enter State]) thinking that would do it, but nothing.

Could use some ideas!
I am trying to identify an expression that I can use in a query to limit
lines used from a data table. For example, I have data collected over
several months. I want to select the data from the last 3 months, the last 6

i have a simple query that references a text box on a form as a
parameter. the text box holds a date and uses the Short Date format for
its Format property...nothing fancy
when i try to use it in my query it returns no records (when i know it

I'm trying to decide if I want to use a query(s) or DSUM & DCount to give me
the total amount of due for a tenant with more than 1 unit. All I will need
the totals and number of units for a form for Batch Payments of multiple
units.

I have the following find duplicates query, which returns the maximum value
in the SASNODemout.NPIEC field.  What I need instead is the query to return
all BUT the maximum value.  Min won't work because I could have 3 duplicate
records and I need two of the three returned; the ...