I have two different ODBC tables and as a result of a make
table query I'm trying to change the Data Type on both
tables to read "text".  One table already reads "text" but
the other reads "number" every time I try to change it the

I have updated office to office XP & in the selcetion
drop down list of XP of insert object when using Access
it no longer offers insert "Image Object" which would
take me to my cam so that I could capture the image &

For each style of product in a certain state for a certain
month, I need a total of units and money. I've got my query
set up to pull the month I want and to sort by state and
style, but just changing the Total row for the quantity and

Hiya, Ive been trying to link two fields so that when i select a valu
from one, the value in the second field should automatically appear.
I have two tables: Lessons and Actionee Details.
The actionee details table has four fields but i am only interested i

I am attempting to link a large DB2 table and all the data
shows as #Deleted, when a view is created on DB2 it links
in fine to access with no #Deleted.
Can someone assist as to what the difference would be

I am now working with old DB that they want a new table
for:
Old: Contracts Table
      Contract number

Not a database, but a table in it.  I was hoping to locate
it somehow, it just disappeared and recovery utility is
not finding it.  I figure it's real name as far as the
computer is concerned is different from what I named it,

how many fields can an access table handle ??
the fields in the table all relate to a specific sunbject [STUDENT], but
the length of the table is running up to 40 fields. i find this
excessive.

Table with just one column which is an autonumber column - how do I insert
records?
--
Tim Ward

Is it possible to get number of days between two dates, excludin
weekends and holidays? Please advise
-----------------------------------------------
~~

Hello, I have a one to many Relationship, Force
Referenctial Integrity and Cascade updating (not cascade
deletes).
the One-side shows Company names

I have a Fee Table with Contract #, Company Name, and many
$ fees for services (no primary key)....I have a Service
Code table with many services by code (both text code &
Number code) Autonumber primary key....

My date field is the traditional mm/d/yy format. I need to
create a parameter query that asks for the month and then
the year. I'm sure DatePart comes into this somewhere, but
wild guesses at the right way to word my criteria have failed.

I am creating a table with a field defined as a hyperlink. The files that these records will link to contain the pound sign (#) in the name. When I construct the hyperlink, Access truncates the link at the pound sign, and thus, Access cannot find the correct link to the file. I ...

What do you all think about not setting up any
relationships at the database level, but instead setting
up relationships in queries "on the fly" as needed?
What are the pros / cons of that approach?