hi,
I have the following 2 queries:
calls_by_status:
TRANSFORM Sum(tbl_CACS_activity_by_resolvedstatusandcontactcode.[COUNT( *

I’m not sure if nested queries is the correct term for a query that gets it
data from another query. If it is, I am using a heap of queries nested to get
the resultant data for my report but it seems to run very slow.
Is there a way of improving the performance to achieve the same ...

I have the following query that needs to be tweaked but I am at a loss as to
what to modify:
SELECT HOTLINE.[CALL DATE], HOTLINE.[CALL TIME], HOTLINE.[CALLER NAME],
HOTLINE.[HANG UP], HOTLINE.[CALLER PHONE NUMBER], HOTLINE.[CALL NUMBER],

I am using a true or false criteria in a query like this in the criteria field:
Whats_Status("Varname")
The function is defined like this:
Public Function Whats_Status(Varname As Boolean) As Boolean

I feel like I have tried everything, and I KNOW this is a simple task, for
those who are very familiar with Access, but I am having the biggest problems.
I have constructed a database to keep track of employees and also use the
dbase as a scheduling tool.  Basically, an employee's ...

Hi. Is there a shorthand for matching a list of items in the WHERE clause?
Here's what I mean:
select * from SomeTable
where

Here's what I'm trying to do.
TblFidNCS and two feilds, AssetID and FAssetID. These fields need to be
compared to the AssetID feild in TblBkData. We need to see if the feild in
TblBkData matches either AssetID of FAssetID in TblFidNCS.

I want to pull the top 5 Values and then group all other values under an
"Other" category.  Can this be done?

I have the following query set up
Field1: Customer Name
Field2:PriceError:count(IIF(priceError)=-1,"")
Field2:CoachError:count(IIF(coacherror)=-1"")

Last week....I'd gotten some GREAT help with 2 items....
Showing all records AFTER a certain Time on a SPECIFIC Date....
http://www.accessmonster.com/Uwe/Forum.aspx/access-gettingstarted/15417/Query-fo
r-Records-AFTER-Certain-Time-on-a-Certain#62cede15d47abuwe)
(The solution was ...

i have four tables with similar headings, i need to combine  one column from
each, into a subquery that i can compare to another table column.  i have
tried union all but cannot be used in a subquery?
any ideas?

I am using Access 2000 and have created a client database that has a
Companies table containing company information, Contacts table containing
contact information which also contains a lookup field to the Companies
table, multiple event tables which contains a lookup field to the ...

I created passthorugh query and Data Source for it for one report. It is
working great for first report, but when I created second report, passthrough
query and Data Source, Select Data Source window keeps on poping-up every
second

I have a query that has null values in the criteria field. What is the
correct expression to fill that field with the same value for all the records
in that result set?

I need to select a random subset of membership records for a survey.  What is
the best approach to obtain a truly random (and unduplicated) subset?