A while back, I encountered some corruption, and didn't realize that Access
eliminated my relationship between the parent and child table.  When I try to
reset the relationship, it won't let me because some data violates the rules.
I'm pretty sure that one or more records in the ...

i am trying to append from one table (NewItems) to another(Main), but get an
error saying it can't append 975 [of 4000] records due to key violations. The
target table (Main)has a composite primary key made of date and itemnumber.
All the items to be added have a new date that ...

There is one query in my access database project depend on Parameter in
running from a form
For ex. Called Form1 and the  Parameter  called  IdNo
When I was using the access database (.mdb or . accdb )  I was setting the

There is one query in my access database project depend on Parameter in
running from a form
For ex. Called Form1 and the  Parameter  called  IdNo
When I was using the access database (.mdb or . accdb )  I was setting the

I have 2 fields from two tables that store dates as text formats.
I am trying to compare them using an iif statement along with the CDate
function.
Table 1 stores the date as mm/dd/yyyy hh:mm:ss and Table 2 stores the date

I have a query that is based on two other queries, each of these queries has
a Weekending Date field but no criteria entered.  The other query that uses
these two queries with Weekending Dates has [Enter Weekend Date:] as its
criteria for both fields.  However, both Weekending ...

I have a table tblCreditApplicationInput which holds all our customer
data for those who are applying for credit from our company.  I
created a report called rpt_Bank_Ref_Letter which we send to banks in
order to check our customer references. When we process data for the

First off I want to say I read a lot of the previous posts about this issue
and none seem to be similar to mine.  I am working on a database someone
before me had created, actually it was two databases so I'm combining them
into one since there is no reason to have two of them and ...

I will be imported into Access a Table that has X's in a field.  I need to
update a table in Access that has his same field but it is a checkbox -
Yes/No.  How do I write an update query to update the Access table to yes
were the Excel table has Xs.  I hope this makes sense.  ...

If I have a table of contact details which contains a Yes / No field...for
whatever reason...
What Query type / Criteria should I enter should I use to return a dynaset
of all the Yes records.

Can I use Min and Max functions in a query?
I tried to build a query where I had the fields or columns under neath.
In the Column NUMOFDAYS, I tried to write an expression but it just gives
me an error saying; Wrong number of arguments or something like that.

One of the fields in a query has an alphanumeric term that looks like
this...
sb1/02/08#5
The first two characters represent the initials of the person who sent

Shows you how naive I am - have been asking in the 'reply' section! Can
anyone just tell me how to access the Table Tools - to merge cells etc. The
'help' section doesn't point the way, not Vista for Dummies! I have found it
before but it seems very elusive. Thanks

I have a table with 20 columns and I am looking to add a column that
searches the other 20 columns and if all the cells in that row are null
enter value in the new column =X and if there is information in any of the
other columns make new column's row value = is null?  Any help ...