Friends,
I have table " Labor record" where i keep records of  all Labor name that
engauged mostly everyday. How can I retrive all labor name for the max date
(the  last date in table) only  for Reports?  In Report I don't need to get  

Our fiscal year runs April 1 - March 31.  I have a query whose date criteria
selects all dates during the current fiscal year (code below) and it's
working fine.
Between DateSerial(DatePart("yyyy",DateAdd("m",-3,Date())),4,1) And

I keep getting "too few parameters" error, does anyon know why.
Set rst = db.OpenRecordset("SELECT Count(ALLPolicies.PolicyNo) " & _
   "AS CountOfPolicyNo, Sum(ALLPolicies.AnnualPremium) " & _
   "AS SumOfAnnualPremium, tblTeamLeaders.TeamID " & _

In a QUERY I am trying to make a field look up a so that if some of the
fields in the same row are equal than it will give the same field listed in
the equal row. For example:  if field [Stop] =2 than look up in the same row
the field [Dock] and compare it to the rest of the ...

I have a linked Sql table in an Access database and I created a query on
that table and assigned with a range on a date field as follows:

I know for sure there are records with the date 1/31/2007 on that table,

This has to be easier than I'm making it.  I have a form with these
fields:
TaskID - number
Task Description - text

I have a series of queries that are tied together in a macro.  Example:  The
macro first deletes the data in an existing maketable.  It then appends new
data from a linked table, changing the formatting from Number to text.  It
then runs a final query that pulls data based on the ...

How can I create a query to delete all records in an Item table that begin
with the letter "s"?

Could someone please give me the syntac for this? Thanks.

I currently have a crosstab query that I used to count the number of each
type of quantity of volume per quarter but its giving me dollar amount vs a
for whole count.  For example:
         Q1                     Q2                Q3           Q4

Hello! I am working with a table of orders that is related to a table of
order activities. An activity record includes a beginning and ending date as
well as an amount.
I am looking for a way to group/total or consolidate by order and to find

I am querying some data in which some records have multiple cost prices
associated with one item.  In these cases, I'd like the query to return only
the first cost price it finds (not all the costs) and then also the
coinciding retail price with that one cost.  Thanks!

I have a report with many subreports. I have Parent / Child Links from the
main report to each subreport. I have checked all the links and they look  
correct, but I still recieve a message to enter a parameter, when I try to
run the report. When I run each subreport independently ...

I need to rank the scores each judge gives a competitor in an event.  I will
be using a query based on 4 or 5 tables but have created a table with the
fields Ineed to make the SQL easier to follow.
what I have is

I need to be able to search a table for any records that are equal to a given
date field and if no records have that date exactly to have it present the
next existing prior date.  I tried doing iif(table date<=given date, table
date, null) and then having this be a total query ...