In Access I have 3 tables linked together, from that I have made reports
through the query.  This has been working perfecting for some time now. But
today, I tried to open one of the reports and it stated 'record deleted'. I
went to the query which stated the same. When I have ...

I have this input data.
1/1/06
2/3/06
3/6/06

I got a table with
Sample number
plus size
minus size

This is what the Query code is and What is between the stars ** is what I
would like  added to
it......Thanks Bob
SELECT tblHorseInfo.HorseID, funGetHorse(0,tblHorseInfo.HorseID,false) AS

I am not able to use parameters in cross tab queries. The same parameters
work well in the underlying select queries.

How do I make a query where I search for somebody who has it's birthday
today. Thx

I have a table from which I want to retrieve a random record.
The table has an identity (autonumber) field as its primary key and two text
fields.  The prmary key values are not contiguous, IOW there are gaps in the
number sequence caused by deletions.

I have one table in which there are first and last name fields and then there
are 6 more fields under which there is just a yes or no answer. users of the
database will want to look at all the names of people who have a yes in one
of the fields, but they need to be able to choose ...

With a table call Historic,
and containing the fields NoEmployee, Date, Seniority
I would like to make a query that will tell me the date that an employee
reach 60 days in is seniority.

I have a field ACTION_DT_TIME which stores a datetime value as follows
200605151507
=YYYYMMDDHHSS
I need to be able to pull out just the Month from this string, which I've

This is my introduction to Access  and even databases (I have some
basic grounding in SQL through Oracle/SAS).
I generated a SQL query using Wizard and got the following
SELECT ISSM_Table.PIN, ISSM_Table.[ISSD Special], OSRM_Table.[Prod Mfg

I'm trying to change the starting value.  I've followed the help program but
getting "About to append 0 rows" and it doesn't work

I have a table where the fields are Area (number), Month (text (rather than
date because some of the data in this field are "unknown")), and Power
(number).
An example of data in this table is:

I have MS Access 2000, but there is a .mdb database for Access 2003
that I really want (a student database for my teaching).
IS there anyone out there that could download and open this file in
Access 2003 and then email me a new copy of it saved as a Access 2000

I have a table which has Expiration_Date and Pmt_Amt as fields. In a query,
I want to select the Max of the expiration date and then also the Pmt_Amt
from the same record that was selected by Max Expiration_Date.
Thanks,