I tried in all possible ways, but I can't find a solution...
I've got 1 table with 2 fields only : Invoice number, Invoice Date.
I wish to retrieve the first 3 invoice numbers per Invoice Date.
I checked on the Discussion groups, but the proposed solutions use 3 fields,

I have a split database that utilizes make table queries.  I won't know the
UNC paths for all the users that will be using this database, so I have the
make table queries create the new table in the current database instead of
specifing the back end.  All of these tables get ...

At predent the only place I can send my Access filr is to an email
recipient.
I want to Add Drive A so I can back up my work,
Any suggestions please.

I have a form with a subform. In the subform is a field ProjNo. On the form
is a command button which, when clicked opens a query. The intent of the
query is to return a list of all the different values in the ProjNo field on
the subform. I've used as a record source for the ...

Despite reading all I can I cannot seem to work around this.
My query is flipping ambiguous dates to US format. If it is passed a date of
say 23/08/2009 it works fine but given the following or anything where the
date and month can be changed it does! How can I prevent this? All ...

I have a table with three fields: Hour, Tank, Volume
I want to create a query that, when run, will take the volume of a group of
tanks, and change it to the corrosponding tanks of a different time.
For example:

How do I write a SQL statement where I want one field unique (MasterCodeID)
but several other columns from the same table, say Field 1, Field 2 that are
not unique?
Thanks

I've inherited a database that needs changes, and haven't worked with Access
much lately and I'm stuck for an answer.  I have a query that works just fine
that returns Region: 01, Region: 02, Region: 03, or Region: 04 depending on
what region a store is in.  The database owner ...

I want to compute taxes on Grosspay in a test access payroll query.
Conditions are as follows:
Grosspay is a calculated field in the query and is monthly.
It must be converted to annual-salary(salary*12) before computation based on

If I have 2 recordsets, both which contain identical fields, is it possible
to merge them into 1, before displaying them on a report?  
Thanks,
-David

Hi. im bit stuck. i need a formula for access whereby it will return
all date entries put in 11 months ago. e.g. today is 05/2007 it will
return all the entries put in for 11 months previous for the entire
month which would be all entries for june. Please help.

I have created a cross tab query with a count. How do I get the cross tab
query to display 0 instead of a blank and/or null?

I have an application  in which I download data from another Access db. On
one append query I format the number field using:
format(Piece.Width,"0.000"). On the other append queries this works great.
All of the fields that I'm appending into are single for the data type with 3

Hi, I have been trying to sum quantities between dates without success. In my
last attempt I get an error message of  "you tried to execute a query that
does not include the specified expression ([SumOfOrd Qty], [SumofOrd Qty]
Between DateAdd("m",-12,[MROs]![Date Open]) And ...

In a query, I have a field (combineddate) based on a union query which
combines 2 dates - dob (date of birth) and doa (date of anniversary). In some
instances, the year is not known and I've used the year "104" for those. With
help from the board, I now have the query returning ...