I'm trying get the top 3 salaries (without ties) for each policy.
Here's my table and sql:
ID    Policy    Salary
1    100    100000

I would like to combine the field values from Address 1 with those of
Address 2.
I am familiar with queries but not exactly sure how to go about this.
Can anyone please tell me  how.

I have this simple query that either displays a value or can be null,
SELECT [Quaterly total number of workshops aberdeen].CountOfTown
FROM [Quaterly total number of workshops aberdeen];
Having read about the NZ function I would like to display a 0 if is

I have a database originally built for payroll.  I need to sum the hours
spent by each employee on individual projects.  For instance, Joe worked on
company 415 on 07/01/06 for 6 hours, company 416 for 1 hour and company 417
for 1 hour.  Ray worked on company 415 for 2, 416 for 3 ...

I have MS Access 2000 and I have an web address in which I am trying to
extract the text between the "=" and the "&" inside a table column.  I don't
know if it best to do this in a Query or VBA.
1.  Can this be done?

I have the following code:
SELECT vwShipments.ACCID, (SELECT X.ShipUnits FROM vwShipments AS X
                           WHERE X.INVDATE = MIN(INVDATE) AND X.[ACCID] =
vwShipments.ACCID) AS [Initial Order Units]

I have two tables with information about students.  One table for current
students and one for expected students.
Both tables have a field called status.  And for each student the status is
different.

i have m
ade a mistake with the email address I am sending message to how do I save
message when I try to correct it

In my database, I have a table named tblMemoPeriod, which only stores one
number field & one record named “MemoPeriod” to store the default period (in
days) of a memo. I’ve also built a form named frmChangePeriod so that the
user can change the default period of a memo, and then the ...

I have a query that reads a date field:
Between [Forms]![pickdate]![fromdate] And [Forms]![pickdate]![todate]
The fromdate and todate values come from a calendar control in an unbound
form. However, the todate is not inclusive as there are missing records. Any

I have a report based on a table, and want to set up a query to limit
the records pulled through.
The report will be run at the beginning of the month, and needs to pull
through all records from previous month based on date field - I am

I have an existing database with table containing information for
approx 400 customers as follows:-
Customer ID; Contact; Company; Address and so on
I have been given a spreadsheet that contains a list of about 60

I have a field which has a description of a file - I need to be able to
"query" this field - I've searched all types of parameters, but logical or
mathematical are not going to work.  Am I out of luck?

I have 1 table named Anomaly and 1 table named QC.  The anomaly table has the
fields X, Y, Target ID.  The QC table has the fields X,Y, Target ID.  The X,
Y fields are blank in the QC table.  I want to make a query that will fill in
the X, Y fields in the QC table if the Target ...

i have one qry"Expense reports" where there is one field "expense category"
which is txt field.
i want to filter this qry by putting criteria.
one of the exp categories is "allowance" .i want to filter like this