Whats a direct query?  

Hi,
I have two tables im looking at comparing data.
In the first table i have the unique id, name and sales data, in the second
table i have name unique id and other customer data but i also have a the

Can I make a query to find info only from the last record entered? I need to
use that record in an expression.
Thanks
Harold

I ran a query got the results. I would like to save these results as my new
table. how can I do that. Could someone help me with this

When exporting a query to Excel, is there a way to override the name of the
worksheet in Excel.  Excel uses the query name by default.  Thanks!

I have a balance field containing currency data that could basically have any
amount in it. I am trying to create a balance band field without writing lots
of queries. This field would show the balance in groups such as £0 to £500,
£500 to £5000 etc.

I have a link table, tblManufacturingInstructionsLink with 2 fields,
ProductCode & InstructionID.  One ProductCode can have many
InstructionIDs, (I know that this is not ideal but this is how I have
inherited it).  I also have tblinstructions (fields instructionID &

Is there a function that would allow me to add a incremented # to a select
query?  For example, a query returns...
Name
------

I have a make table query that calls a (public) user defined function
(Percentage).
When I try to execute the make table from outside of Access97, eg from Excel
I get an error 3085: Undefined function 'Percentage' in expression.

I have a query to select the MAX of the inspectionID by StructureID from the
inspectionhistory table. But if there is more than 1 record per structureID
and there not identical, I get both of the records instead of the
inspectionID MAX.

I have the follow query that returns all the details pertaining to each
ticket, plus how many actions exist for that ticket...
SELECT * FROM Tickets
LEFT JOIN [SELECT TicketKeyLink, COUNT(*) AS ActionCount FROM Actions GROUP

Access Query
I have a query with two columns: ItemCode and Value.
I need to create a third column accumulating the preceding values on the
column Value. Put it in another way I need it to sum the value in preceding

I am having some problems designing an update query
Here is my current (non working) query
UPDATE    dbo. myTable
SET          dcStatus = 1

I just started using Access not too long ago, and I need your advise on
how to add a new column (Column C) in my in an already exisitng table.
however, I want the value in this Column Ci  to be derived from
muliplication of values in Column Ai and Column Bi. Any help will be

I use SQL once a year so struggle on the simplest tings.
I want to retrieve the entire row/record for a series of the max values.  
Its easiest enough to get the values to display is they are in the GROUP BY
clause but its returning incorrect results.  I think I need a statement