I am sorry I caused confusion with not explianing it fully. First what I have: Table 1 has a full listing of data. I work off this listing, so if there is a...

I created an Inventory Control Database using the template in Access 2000. My only problem is that the products table does not meet my needs. I need to...

Using access 2000 (because that is what client has). I have a table with a large # of fields, 209 at present but it will come down a few when test fields are...

I am aware of the active X calendar 11 control and understand its benefits, implications and properties. My "query" is I would like to have my date fields to...

¼ìÄê¤ý, ¦ÊÅܬP§g, r102030r, ¥§¶ø·s¤B 4 ±ø¥´¹v¥J.

Os voy a contar una forma de ganar fácilmente un dinerillo extra para cualquier capricho o para llegar a fin de mes. Hablo de ganar dinero por Internet viendo...

Folks, I have inherited an Access 2000 database that contains about 50 records. The database is not normalized, but I'd like to make it so without having to...

I know this is table design 101, but I can't seem to find anything in the help files... What is the difference between a key and an index? Not only from...

I am building an Access DB which will contain several tables. It is going to be used to generate XML files which must conform to a specified schema....

hi folks i am designing a database for a firm that has annual period of the accounting. where they close all accounts at the end of each year. Balances are...

Hi folks, When I try and register new persons in a database of mine it says: Constants, fixed length strings, arrays, user-defined types and Declare...

I'd like to have a field in a table that records the date/time that the record was last updated. I'd like this field to be automatically updated whenever any...

Does anyone know how to add "x" number of records into a table, where the "x" is a user inputed number, and whose value is not constant. (i.e. add 5 records...

HI I have the round function set with 2 decimal places on a currenty field in an Access table. This field calculates quantity x cost. The cost of an...

Get your aspirin and other headache pills at the ready... I have already posted this in the thread "one-to-many relationships" in "general questions" but have...

I'm using two unrelated tables to append another table. Each time I run the query, it adds the correct information, but does it twice. Table1: Employee ID,...

I all I am quite new to all this database designing. I have 3 tables: Suppliers_table, Call_table, Transaction_table. The Relationships are as follows:...

I have several existing tables with data input. I need to convert an existing number field to an autonumber field. If I can not accomplish this and must...

We keep a yearly list of students and schools. I use 3 tables: one for the schools, one for school reps and one for the students, related through a "codes"...

Hi, I am trying to establish relationships between tables by using the ID numbers as the foreign key. For example using the ActivityID as a foreign in the...