Appending challenge,More complicated than the previous one, 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,

Running the query using two tables result in over 5,000,000 records. when I
try to make table I get the massage: Cannot open database “. It may not be a
database that your application recognizes, or the file may be corrupt.
If I run a much smaller version of that query I have no ...

I have two tables that are related table A and table B. Table B contains
records that are date/time stamped.
What I need to do is to join the rows in table A with the last (in date/time
sequence) applicable record in table B.

1) On formLoad, I need to show only those items which are unassigned.
2) I need for the end-under to select only the items they are assigned to.
3) I need an option to select "ALL" so I can view all items.
Any insight offered would be appreciated!!!

I'm using MS Access 2003.
In my query, in lots of yes/no columns, I enter criteria.
In my case expressions like
    (=Forms!frmCriteria!checkboxN) OR (Forms!frmCriteria!checkboxN=False)

I would like to construct a query that selects all records from a table where
the value in a specific field is unique.  My preference is to leave the
original table as-is.
In hindsight, this table should have been set up to prohibit duplicate

I have a db with fields: id date/time.  I am looking to create a count where
if it's the first date/time for an id, it states 1, then if second, 2 and so
on and so forth.  I'm having trouble getting count to do this b/c of keeping
the date/time variable in there as a sorting ...

i need a crosstab query
apples  oranges  bananas
 10           20       30
I used to do it all the time, but the cross tab query

I want to trim data but not all the fields have the data?

I have built a command button on a main form that runs a select query and
displays a the result in a subform on the same main form. when I press the
command button a second time to run the query again it says that it can not
get control of the select query in order to run it ...

I am trying to run an update query where if the Date/Time field is blank, I
want it to enter today's date. Here's what I have:
UPDATE Royalties SET Royalties.DatePaid = Now()
WHERE (((Royalties.DatePaid)="IsNull"));

In the query below, the sub-queries "TRI OCS CPA join" and "PAR3417 results
vs detects by works" do not have the same structure; however, the things
selected from them (and unioned as far as I know) do have the same structure.
I tried a similar query out and it did seem to union ...

I have a combo box on user pick form where users can choose one Operator and
leave the box blank to return all records.  How do I revise my below code to
allow users to leave the [frm_Pick_Operation_Emp_Chart]![Operationcmb] field
on my pick form blank?  Thank you!

The following union query results in a memo column returned by
qryPkgRuleIssues being truncated. The query when executed standalone returns
the full text of the column. How do I avoid this problem?
SELECT * FROM qryRptPkgIssues

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 ...