Access 2007,
I've created the following query from two tables:
SELECT tblTrnsctn.TxnDate, tblTrnsctn.Amount, tblCoa.AcntNmbr,
tblCoa.AcntDscriptn, tblCoa.LeadSheet, tblCoa.qbListID

For discussion's sake....
I've just finished developing 9 or 10 queries, (makes, appends, deletes),
that will take 14 imported ISAM files, normalize some of the nastier data,
and extract "yesterday's" business into a tab delimited file.

i have a union query that selects certification date from a number of tables,
I have been asked by the users to only show the most recent certification
date. How would I format the following query so that it only resulted in the
most recently certified records.

Probably not a good subject line but.....
I have create a report that has data sourced from a query.  I can create a
table (Tbl_Dept_Nos) that produces a summary list of department numbers.  I
can create a form (frm_Report_Generator) with a button (Btn_Create_Report) on

I have a very weird situation that I'm hoping some of you might have
seen (and possibly resolved).
We're migrating data from one system to another and the business rules
have changed.  System 1 allowed a user to create a record for an item

Good Day,
I have 3653 rows of data which have the following information by column;
ItemNumber    Quantity     Date
PRN223           56             02012003

Hi everyone,
    I have a qry that includes Client, Year, and then about 20 more fields
of mostly dates.  What I would like to set up is a cross tab that would show
each client and year as rows then show me for each client and year which of

I have these Medical codes that should have decimals two spaces from the
right but when I get the files from IT they don't include any decimals. How
would I tell access to insert decimals in that field. The data format is text
because some of the codes contain letters. Thank you.

I'd like to join queries and also keep all rows in each, regardless of
whether all rows in both queries match.  The closest I've seen is an outer
join, but an outer join drops the non-matching rows from one of the queries.  
How do I get around this problem?

I'm writing a query to calculate inventory by comparing my Product table with
my Sales Orders table. My results only show items with sales activity, but I
want to also see the product names with no sales activity, and their current
quantity.

I have a subform that is based on a query.  The results are displayed on
screen.  When a user clicks anywhere on a specific row, I want another query
to run that gives details on that clicked item.  I can get the query to run
when a row is clicked, but I cannot figure out how to ...

I am trying to create a simple database for creating a round robin schedule
for a tennis league.  I have a table with 16 players, a table with 4 courts
and a table with each date the league meets.  I need to be able to create a
random grouping of all 16 players on the various ...

I have 5 queries from which I'd like to create a new query.  I want to
extract columns from each of the 5 queries to make the new one.  They would
all be 'joined' on the same common field.  I think I can do this by doing 4
successive joins, starting with queries 1 and 2, then ...

Using an exported Q&A database (ASCII), we imported the data into an Access
table.  We have a field called Name. Name consists of Last Name, First Name
Middle Name. How can I get these names into a Last Name field, First Name
field and a Middle name field?

In another post someone says to use delete/append instead of make when
repeatedly importing data.
On a daily basis, I will be importing data, (14 ISAM files), rebuilding 7
intermediate tables, (to somewhat normalize some of the data), then running