I have a time field (like 1:30 PM) indicating a student's performance time.  
I want to write a query that will select all the students who have been
assigned to perform at the same time (i.e., 1:30 PM) as well as all the
students assigned to perform during the time period from 60 ...

Hi! I have a query that displays the value "Descartados.Cod_animal" as
many times as "Sugestão.Cod_animal" matchs the conditions. What I want
is that the query shows me only one record per "Descartados.Cod_animal"
and discards the rest of records that matchs the conditions.

Hi to everybody.
The problem is very simple, I suppose:
I need to use  this value:
IIf([store_2.ID_ROOM]=1,[@sgl],IIf([store_2.ID_ROOM]=2,[@dbl],[@tpl]))

I have a query that works fine until I add the following...
... AND PR.ATU='Yes' ORDER BY....
I've tried....
... AND PR.ATU='True' ORDER BY....

I am using Access97 and I have an Oracle ODBC table that I use with queries.
On one field I have a input criteria field. I get no results on some criteria.
What is happening is that the field is 5 character text field. If the field
is only 3 characters that I input I get no results. ...

after a user selected one or more item from a listbox, i click on a button
and i run this code
Private Sub cmdRecherche_Click()
    Dim strIN As String

What I would like to do is create a query that will create records for each
serial number in a series.  I would like to be able to enter the beginning
number and the end number and have it automatically fill in the rest of the
information.  Example:  Serial #'s 00123456-00123458; ...

Hi Boys,
i'm italian and i need your help!
Is there the possible to realize an access query like this?
IF SELECT ETC...ETCCC.... IS BLANK THEN

I am being very dense on solving this problem and I know that it can be
quite simple.
I have two tables tblAcadGrade and tblPastoralGrade. The first table
will have a series of records associated to each student (a record for

I made big DB everything is working alright only Viewing last report.
I have the report base on Query and in that query i made all the field Total
as LAST.When i run the query it show the record of the one before last.
Help me please.Thank u so much.  

I need to have a field to generate the report number with the following
format:-
The first part consists of four digits for each year.  It could be obtained
from the date field entered manually.

The following query should evaluate the Expiration Date ("ExpDateFormatter",
originally a string value, now formatted in a separate field as a
"mm/dd/yyyy" date) and compare it to the "last day of the period" (a
variable) plus one month.  I keep getting an error stating this ...

I'm having difficulty using the sum funtion to add up fields with time
indicated in hours:minutes:seconds in
access.  When I cut and past into Exel it gives me an error 'Negative dates
or times are displayed as ####'.  I can add up small amounts of time and the

I'm having difficulty using the sum funtion to add up the date/time fields in
access.  When I cut and past into Exel it gives me an error 'Negative dates
or times are displayed as ####'.  I can add up small amounts of time and the
function works just fine, so I'm wondering if ...

I have an append query which is launched when a user selects Case 5 from a
seven level Options Group (Frame1) from an A2K form (‘Screening Log’) as shown
INSERT INTO [Patients on Follow-Up] ( Dummy, [Study#], [Reg#], [IRB Number],
MR_Number, [Pt Initials], [On-Study Date], Site, ...