i did a qry, but in one colum the records are duplicate. i want no show those
record, how i can do.
my SQL
SELECT dbo_CMC_PDVC_VAR_COMP.PDPD_ID, dbo_CMC_PDVC_VAR_COMP.PDVC_EFF_DT,

I want to create a relationship between two existing tables, but I can't
find the query. I'm using an Access 2000 Database. I've tried these queries
(among many other, all of them fail):
ALTER TABLE [SecurityGroupsObjects] ALTER COLUMN [Object] INTEGER NOT NULL

I have and complex table that is preceded by a heading (not part of the
table) "Schedule "A" - Parties Responsibilities".  No matter what I do the
table is forced onto the subsequent page leaving the heading alone on the
preceding page.  Suggestions?

I have a form w/ continuous subform that switches between queries for the
recordsource.  The only difference between the two queries is that there is
an additional table in one of them.  The result is that one of the fields
becomes locked and I cannot change my selection...but ...

Calculations for all costs are rounded up to the next dollar on our invoices.
The business office personel inputing payments have entered dollar amounts,
like $109.49 which should be $110.00. There are many payments entered in the
table, but few of these payments entered have the ...

I am having a problem getting all the records in my main table to show up on
a query which has a Left Join to a second table.  SQL follows for a Query -
   [Audit Data] is the main table
   [Behaviors] is linked to [Audit Data] on the field [Index]

Very noobish on Access here, so please forgive my ignorance.
I' m trying to make a query where one of the fields is selected by a form.
Something like this:
Expr1: (select fieldname from [tablename] where fieldname=[forms]![formname]!

I need to create a number of Union queries, based on tables with a number of
common ID fields, such as TraderID.
My question is, is it better to join the two raw tables in a Union Query,
and then query the Union Query with a Join to tblTraders to display

greetz and thanks in advance for assistance with what i thought should be a
pretty simple task......
i am helping someone who has a single table (may eventually move to
normalized tables but currently still just one table) with fields such as

Is it possible to find the value of a field in the previous record entered?
I have a database which I update, but the value of one field is dependant on
the previous record.
So if Field 1 of Record1 is 7, then Field 1 of the next record could be 8 or

I am having a hard time trying to get my query to work.  I only want to
return the maximum record from group of records that all have the same sales
order ID.  I have an autonumber field in it that I can use to get the maximum
from this group.  But, my query keeps returning ...

I have two tables: T1 and T2 joined by Store #; I want to compare the T1 and
T2; when T2 has a new record = new store, I want to append the record to T1:
How do I do that?
Thanks,

I have a query that stems from a table with an autonumber field already
assigned.  One of the fields named 'bp_order' is a number.  I need to assign
a record number to each record matching bp_order in descending order.
For instance,

I want to omit ALL records if a duplicate entry exists in a query

I have a database which has a list of products and prices in one table. I
have another table which is updated each day from a file of new sales. If a
new product is sold which is not in my pricing table then I don't report
correctly. What I need is a query which will tell me ...