Small prob - any help guys?
I have a query like below.however say the one dog has the same best rating
more than once, my curent query brings up both those values.but i would like
it to only select one of the dogs best runs based on the best rating and the

I have 2 tables A and B. I need to update a column in table A with the
contents of the same column in table B. To match the rows I need to compare
on 4 other columns in each table.
Basically what I have is 2 identical tables but one column is in error in

In the grouping option there is a count option, but not a distinct count
option. How can I get a distinct count of something, short of a series of
queries?

I have a table with one numeric fields.
i want to add a record number field in a query
Look simple but i cant do it! - help
I have: order no

I received this reply to my former question.  Can someone let me know if this
is true?  Would it be possible if I cannot use a sub query within a query
that I could code this using a module on Open Form and update the Control
source with the results of the queries?  I would ...

I am having problems formatting a SQL Statement with Multiple joined Queries.
The query works in three pieces as named queries, but I want to pull it into
one query to put behind a form.  Please help me find code that will help me
with the structure.

TRANSFORM IIf([Manufactured]>0,"X",Null) AS Expr1
SELECT dbo_PlantProduct.ProductCode
FROM dbo_Plant INNER JOIN dbo_PlantProduct ON dbo_Plant.Code =
dbo_PlantProduct.PlantCode

So I was almost done with this entire databse, and then i discovered a major
flaw. When there are two records with the same date, it throws off the entire
query. Most of the fields, for some reason, increase exponentially. When the
records have different dates, the query looks ...

I see where there is generic sample code to do what I need, but I only have
Access 97 on the computer I'm using today, so I can't open Duane Hookum's
database.  Does anyone have any ideas for how I can do this?
Thanks!

How do I create a criteria within my query that shows current user logged
into a form?
I have created a form that allows whomever is logged in to populate and it
reads that the current user no problem.  Form is perfect but I want to create

Good afternoon.  This question may have been answered, and I have not
searched for the right criteria in access monster to find it.  If so, I
apologize for the repetition.
I need to update a field in several thousand records.  There are two fields

Forgive me if this is rather long.
I have an Access database that is created by a state agency and is
protected.  One of the tables has detail information by company.  This table
is linked into another database I created from which various queries are run.

I currently have a Query with two tables (tblDates, and WIP). tblDate
has two fields, an ID field and a date field.  The Date field is
listing of dates from 1/1/1998 through 12/31/2015.  The ID field i
an autonumber field

I have a pop up form that allows the user to view records in a query. How do
I prevent the display of the last blank record (the one with the * next to it
in datasheet view
Thanks

Hi and thanks in advance.  I have a union query on two tables.  3 fields in
each table, same names.  When I created the Union query and run it, it asks
for parameter?  Can I eliminate this and just open the query and see the
results?