I have a table laid out as follows:
Record#   ID    DATA
1              1     LIS
2              1     LIS

How can you retrieve the latest 10 records of, for example, 5670 records
within a database?
Where rowcount<10 ?? Oracle isn't it?
Thanks in advance.

I have used an SQL union query to join 2 tables and created a table from
this query.
Then i've used a totals query to identify duplicate records based on date.
Then i've created a delete query to get rid of the duplicate records.

Using Access 2003.
I have a strange situation when I create an append query. One of the
tables is not available from the list of tables that is presented to you
to select from when the 'Append to' window pops up. All the other tables

I have a large database of patients that I have set up a query to only select
patients in a specific floor.  I want to create a table/form in Access OR
export the data to Excel so I can make a check out list to pass to other
providers covering for me. Below each piece of exported ...

In Access XP I was able to create shortcuts for various database objects to
the desktop so a user could immediately bring up a form or report. I
upgraded a user on a new PC to Access 2007 and can't figure out how to do
this. Would appreciate help with this.

I have tblAgency with frmAgencyDetails for viewing the details. Most
of the fields are locked for editing as people were overwriting
certain fields. I have a link to another form frmAgencyEdit (which is
linked to the specific record) for staff to edit. It has cut down on

I am starting to write VB for my databases. Good so far but in some
databases for example when I am in the VB Editor and write "DoCmd." I
get a list of options but then it disappears. It seems to last about 2
or 3 seconds.

I have a field named cost and I need to increase it by 15%, how do I enter
that expression in a query?

The following code is in a query, written in a New Blank Query, not using the
Grid. The code when run yields "Invalid SQL statement Expected "DELETE",
SELECT", etc.
and no data sheet is returned. If I put the code in a standard module and

Good Day,
I have a form that is linked to a query.  THere is a search combo box that
the user can use to select a specific record and view the details of it.
I have a button in the footer of the same form that enables the user to

I was wondering how Access ( 2000 an onworth) are handling
concurrency issues when performing transactions.
( If I am in the wrong newsgroup please point me to the corrrect one.)
As I understand it, transactions are performed in-cache which to me suggests

I'm using Access 2007.  I have a query that I print from datasheet view.  I
need to draw attention to a specific column.  When I try to change the
background color of just that column or change the font color of just that
column - it always changes the color of the whole data ...

I have two tables: Customer Orders: fields are Customer Number-autonumber,
First Name-text, Last Name-text, Price-currency, SKU-Number.
The other table is Products-SKU-number and Description is text.
I would like to create a query that has the First Name, Last Name, Price and

I have a field in my table that is text and has any of these combinations.
AM
PM
AM/PM