I have 3 different fields in my table, one is a 2 digit number field, one is
a 3 digit autonumber that starts at 001, and the last is a 2 character text
field.  I need to concatenate these along with some special characters
example:  04-001-AH    to show up on my form.  My ...

How can a database be set up that includes Professional standards, courses
and learning outcomes/objectives.  A curriculum mapping database.

I have a field with currency format.
I would like all numbers entered in this field to have a negative value.
any tips
thanks!

G'day ppl,
Here's my dilemma, the db is for a boarding kennel.
I am trying to combine the owners uniqueID with each of their animals e.g
Client1 has 2 dogs, so in order to identify their dogs, I need something

When you want to create/modify master-detail records, what are the most
practical ways? (For example: having partners, and each partner has some
sites, contacts, discount prices.. etc)
I know two methods, please complete the variatons of yours:

Can anybody tell me how to customize the contact fields so I can use outlook
much like I use ACT 6.0?

I have inherited a monthly timesheet, which tracks employees flexible working
times.  The daily hours worked are given as 7 hours 24 minutes and there is
an expression of =0.308333333333333 shown in the default value of TblDay in
the design view of the table.  My question is how ...

I am setting up a database in access 2003 (file format: Access 2000).
After creating the structure (tables, queries, etc) the database looks
messed up with all objects together.
Is there any way to organize tables in folders ????

I have a table in access where one of the fields is a hyperlink field. In
this field I have included various filepaths exluding the filename (ie.
various folders). The thought was that when the user clicks on this
hyperlink, that should launch windows explorer which would open ...

I have prototyped some tables in Access to show "proof of
concept".
Is there a way to "upload" these table structures to SQL
Server 2000?

When I look at my relationship window I have duplicates of most of my tables.
They arn't there in the data view of my tables.  If I delete them in the
relationship window they pop back up when the relationship window is
redisplayed.?

I created a table using MS Access 2003 (Which uses Access 2000 format
database), the default value for the attribute, "Allow Zero Length String"
has been changed to Yes.
Can anyone please verify, why it has been done?  Is there any way to change

anyone know how to have one field for say author and then swop the text round
as in enter john smith and save and display as smith, john

How I enforce referential integrity in unary relation, just like i enforced
in binary relationship,

How do I change footer, headers and logos in an access database?