I have a database which records businesses and the activities our managers do with these businesses. I enter the data in this one form that contains subforms....and whenever a new business comes up I need to enter it into the database. The autonumbering system generates the next ...

Hi List,
I have a table which has been manually updated with an
ID.  There are unique values but there are some gaps
between numbers.

I can't seem to find a way to make the fields in a
datasheet line wrap so the height of the row automatically
increases to accommodate the text without truncating it
and without expanding the width of the field.  Is there a

Hello all. I am relatively new to Access and SQL (started playing with
it a few days ago), and so I have a question on the best way to move
multiple authors into a junction table.
Here's the deal:

I have what might be a very strange situation.
I purchased a license for Microsoft Office XP for home use.  At work, we are using Microsoft Access 2000.   I inherited a database that has been locked down and was originally created in Access 97.  Since the databases rollout over 4 ...

Can someone give input on table design?
I'm setting up a database which will be used to generate employee schedules for the
Emergency Department.  I need to schedule 18 employees every 24 hours.  Shifts are
mostly 12 hrs long, with some minor deviations.  The shifts start at ...

I'd created a very simple database with only one table. In this table, it only contains 1 field with Field Size = double and Decimal = Auto. I'm tried to key-in some numbers like 0.515, 0.525,0.535 and 0.565 into this field. When I retrieve this data using a query with round to 2 ...

I'd like to restrict a set of reports to a certain time
period -- this or that month, quarter, year, etc. Which is
better, to parameterize the report (launching it from a
form), parameterize the query underlying the form, or to

I'm trying to design a database for a customer inventory system.
Some of the customers will have tier pricing and some will have their own specifying pricing.
Pricing will be determined based on the category, desc, thickness and measure of the product. I created separate tables ...

I have a query that pulls all counseling sessions during a set date range.  There may be many counseling sessions for 1 client, so 1 client could be listed 3 times.  I want the total clients counseled, so I need to get rid of the duplicates and only count each client once.  Does ...

In Access Table Design View, we can easily define an autonumber field or
column of a table with a Fied Size of Replication ID, which is the synonym
of GUID in Access. Then, how to define an auto increment GUID field just
using the Jet SQL? Please help!

Hi I'm designing a database for my A Level project and I
was wondering whether there is anyway to include a
calculation in a tabe. I have one field for postage, one
field for the value of the item being posted and I was

   I have a client i am trying to help out. Her programmer is unreachable
who created the data base. Her administrator reset her machine and she has
lost MDW files for the data bases. I was wondring if you guys might know how
to get contro0l of this database again

I have a form and a subform that have as their record
sources queries based on TblInvoice and TblInvoiceDetail
respectively. These two tables are linked by an auto-
number field [InvoiceNumber] that is the primary key in

I am creating a form with several database tables.  How do
I populate each of the tables that have similar
information?