I am convirting excell spread sheet with formula's to Access database and I
run into this question how to imitate Vlookup function in Excell. For example
in my excell file that I am trying to convirt to access I have a value of "1"
in cell A1 and

I trying to prevent appending any records from my temp table into my perm
table that have the same run date.  I thought this would do it, but no luck
INSERT INTO RunDate, Customer, City, State
SELECT RunDate, Customer, City, State

Expr1: DLookUp("[txtDesc]","tbl15702UT","[txtDesc]=" &
[tblUTFIELDCODES]![FCODE])
I need to evaluate a field (txtDesc) look up the value in another table
(tblUTFIELDCODES) and replace that value in 15702UT with the associated text

I have set up a reporting DB which will export data from queries into excel
on the users c:/ drive.
To do this i created a simple user from with Start Date, End Date and Client
text boxes.

I am trying to age transactions into 30 days, 60 days etc and have put
together the following script but is giving a syntax error on "AS" on the 2nd
SUM line, can anyone please help me.
SELECT

Transaction table has ONE key field...Autonumber called TransID. No other
fields are marked as "No duplicates". I'm inserting some transactions from a
linked spreadsheet. Has worked exactly as written before. SQL looks like this:
INSERT INTO tblTransactions ( PartNbr, TransNbr, ...

I'm trying to write a query that will return no more than, say, 20 rows. In
some forms of SQL there's a simple LIMIT clause, but this doesn't seem to
exist for Access. Does anyone know how to do this?
Thanks,

This is a query I have created that picks up the top 3 dates for this
data (for example) :
Tree Pos2 Date
1      15     23/08/2005

I'm quite new to all this but does anyone have any idea why this isn't
working?
SELECT *
FROM COMBINED

I have two tables, one is for employees and the other I use to track crime
report numbers.  I need a query to total the number of arrests, warrants,
adults, juveniles, etc. for a specific month in order to do the monthly
stats.  However, I need to include all the employees ...

I am trying to do something that I believe requires nested SQL. I am having
a devil of a time with understanding how nesting works!!
Here is what I am trying to do:
Query has 1 table as input. The table has a multifield key.

I'm using this UNION Query that worked fine untill I added the WHERE clause.
Any help is appreciated.
Thanks
DS

I have a crosstab query as follows:
TRANSFORM Sum(tblUnionData.minutes) AS SumOfminutes
SELECT tblUnionData.Last, tblUnionData.First, tblUnionData.SID,
Sum(tblUnionData.minutes) AS [Total Of minutes]

How to do it in code?
I have a crosstab query and had hard time to create report based on it. I'm
thinking send query result directly to Excel and open that Excel file. How
to do it in code?

In my version of MS Access 2003, I no longer see the wizard for a query to
find duplicate records. Did that go somewhere else or is it no longer
available?