When I run the query below, it asks me to enter a parameter value for
TOC.source_name.  TOC.[Source_name] is in the select statement and
Source_name is a field in the sub-query TOC, so I thought I had it covered.  
Any idea why Access doesn't recognize it?

I am tracking medical student attendance at daily lectures.  I established a
text field in which to track a student's attendance at the lecture with the
first initial of day name and date as field name.  If they were in attendance
I put "Y" in the field if they were not there I ...

I have a master table that link to a detail table. The query will
return the name column from the Master table as well as other
information from the detail table. The relationship between the master
and detail is one-to-many, so when I link these two tables, the name

I have a very weird situation that I'm hoping some of you might have
seen (and possibly resolved).
We're migrating data from one system to another and the business rules
have changed.  System 1 allowed a user to create a record for an item

I would like count the number of clients in my table that fall into the
following age groups in my query or report.  62 and over, 51-61, 31-50,
18-30, 13-17, 6-12, 1-5, Under 1.  I currently run 8 queries with the count
feature using Age Criteria changing each time and based off ...

I made a delete query but get the Error 3086. Following the discussions here
I added the "DISTINCTROW" but still I get the error message.
the query is as follows:
DELETE DISTINCTROW OrdersReceived.*, OrdersReceivedSubQuery1.ClinicID,

hi, i need you all help. I've two table which is table DO and table time
sheet. Table DO have 4 field, that is DO number, DO qty, DO date and PartID.
Table time sheet have autonumber, PartID, Packing Date, Location, Lot no,
Packing qty and delivered status. now i want to do ...

I am trying to write a query in Access via SQL that takes two tables, neither
of which has a primary key (and I cannot give a primary key to one of the
tables as it's a thrid party table) and returns the records from PrintJobs1
that do not exist in PrintJobs. I intend on ...

I have a table and these are the columns I need to work with.
All fields except id are text from a mainframe.
I have added the nextassy column so it is blank
What I am trying to do if possible is to have a query look at the pn, read

I have a database in which my Invoice table has a unique Invoice ID. The
corresponding Delivery note number is mentioned in the same table. A single
Invoice ID may have mulitple Delivery Note Nos as invoicing for many
customers is done at the end of the month though delivery of ...

Is it possible to create a report that draws on data stored against each
Access report?  I'd like to create a list of all reports showing which Record
Source each report uses.

I Have a crosstab query, which provides sales per month. I have two
questions on that:
1) Is it possible to present the data from Jul - Jun (or any other
combination) instead on Jan - Dec?

Appending challenge, I have a huge data over 750000 records that I need to
mange one of the challenges I am facing is as follow:
Table1 is a list of SurvyID, SiteNo, SpeciesNo and SpPresence where SurvyID,
SiteNo and SpecieNo are the unique combination.

Some time ago (3-4 years) I remember discussions about the performance issues
of Requery vs Refresh.  I know that 'RunCommand acCmdRefresh' superceeded
(replaced) DoMenuItem, 5...' in the late 90's.  Supposedly ( as my memory
serves) Refresh was better for performance than ...

I have a number field in my query and I need the criteria to be...
Not Like 6
Not Like 9
Not Like 10