I need to get the last  POCost from the transaction log from 2 tables:
TrxnHeader and TxnDetail.
Fields from TxnHeader: TxnType, TxnDate, TxnGroup
Fields from TxnDetail: PartNumber, POCost, TxnGroup

I have a between date field and I want to include all date if the parmeter is
blank.  How can I do that?

Does anyone know if MS Access comes with a tool for batch file access to an
MDB file? I have a simple 5 field MDB and want to run queries at the shell
level.  
If not, what good tools are available?

First, let me say that this query isn't mine, but it does almost
everything I want it to do.  What it outputs is a horizontal columnar
calendar from a vertical table with the structure:
<RecNo><ID Number><Date><Mem Type>

I have the following Union Query and when I try to run it, I get "The
OrderBy Expression ContactKey =1 includes fields that are not selected
by the Query."
I'm confused as ContactKey is in the first select and the Union:

I ran a query with a Is Not Null function on the PONo on a table that
retrieved many cells that have no data in them. My query is:
SELECT tblLinkPoNAndPartsAndPrN.CabPN,
tblLinkPoNAndPartsAndPrN.PartQtyPerCab, tblLinkPoNAndPartsAndPrN.PONo,

The following query is supposed to calcualte a date, which it actually does.
Most of the calculations work. There are a few cells that have no answer
(calculated or otherwise). I'd like to know how to get every cell to have an
answer.

I need your feedback.  I have two tables.   One of the two tables has
missing information.   Your help would be much appeciated.
When I try to select "Include All Records from Table #1 and those
records from Table #2 where the joined fields are equal" for two fields

As my initial thread ("Very slow query") was unfortunately unsuccessful
(many thanks to Tina that put a lot of time trying to help me), I am
starting this new one.
I have a very simple file (Main) that contains 48 fields, near of 800

I built a Main table, normalized, containing about 800 records.  It will
grow to about 1600-2000 records.  21 secondary tables (code, description)
are linked to the Main table.  All the keys are indexed.  On the Main table,
all secondary tables are link in the way showed in this ...

Here's my situation. This database is being used to track cash dividends.
Most dividends have what is called a "Ex" date. In some rare cases there is
no Ex date given to us. What we need to do is subtract two days from the
record (Rec) date. If the subtracting two from the record ...

Hej
If i have a querie from many tables
is there then away to make a uniq field
in the quirie for every record

http://support.microsoft.com/kb/239482
Jet seems to support user-defined functions by I can't find any
examples on the web. I've found examples for other systems e.g.:

What follows is a clunky delete query that is designed to get rid of
records where any of the following conditions are met:
1) sex is null
2) age is null

I understand SQL is a set language and the Jet engine is based on SQL.
I was wondering if there was a shorthand for defining ranges of numbers
so I could do things like return all integers say between 1 and 100
that aren't in a given field. Obviously If I already had a table of