| Thread | Last Post | Replies |
|
| compound primary key versus autonumber | 31 Dec 2005 21:03 GMT | 11 |
I'm creating a table to hold conference call minutes. Each call must have exactly one Study, exactly one CallType, and exactly one CallDate. I'm torn between two designs. Do I use a three-field composite primary key or do I create a CallID Autonumber as PK and add a composite ...
|
| Dividing table | 31 Dec 2005 16:06 GMT | 8 |
I have a tech inventory database. It has one table with about 50 fields on it. The first field is "item". ITEMS include computers, software, servers, etc. Can a query include a field like "item" multiple times? I'm having difficulty creating such a query and I'm wondering if ...
|
| Table design for School Registration system | 31 Dec 2005 12:36 GMT | 1 |
I was wondering if someone could help me a bit here. Im trying to desing an electronic register system for a school. In terms of the table design, I obviously need a Student Details table with such attributes as ID, FNAME, SNAME, Age, Tutor Group, Class, Dependant.
|
| how to create a multi-part IF statement | 31 Dec 2005 12:03 GMT | 6 |
In an Access database form I have a drop down field that has three possible choices. I want to create a calculated field with an IF statement that says if choice#1 display "CHOICE#1", if choice#2 display "CHOICE#2", if choice#3 display "CHOICE#3" otherwise leave this space empty.
|
| EXCEL | 31 Dec 2005 06:13 GMT | 5 |
HOW DO I GET CELLS TO EQUAVAL TIME? AS IN 2:00PM + 6:45PM = 4.75 HRS.
|
| ?is my table design poor? | 31 Dec 2005 04:41 GMT | 5 |
I need to create a database to track employee movement (new & terminate). I m afraid I have poor table design, which cause me to supplement many queries to prepare monthly report. Would appreciate comment & suggestion on my table design
|
| delete query will not work with tables joined in the query | 31 Dec 2005 03:26 GMT | 6 |
We have two tables in a query and joined on ID for a one time data project and we need to delete some records from one of the tables. We are using the other table to identify our records to be deleted. Our delete query won't allow records to be deleted. We get the error message ...
|
| How can I create a Field that gets a value from a calculation? | 30 Dec 2005 23:56 GMT | 2 |
I have created a database, there is two fields Minutes and Hours, I wish the Hours field to perform a calculation of Minutes/60 and automatically get the value, how can i achieve this?
|
| Referential Integrity | 30 Dec 2005 21:09 GMT | 6 |
I have three tables that I am trying to build relationships for: Employee Table: which has Name,Address, and EquipNum with EmpID as the primarty key. Equipment Table: which has CompCode with EquipNum as its primary key
|
| Can Time fields be added to show total? | 30 Dec 2005 20:37 GMT | 7 |
I have two time fields a STime and ETime. I need them to add together to show a total number of hrs in a separate field. Can this be done?
 Signature Thank you!!
|
| Access should provide for relative path links to tables. | 30 Dec 2005 13:24 GMT | 2 |
Currently, linking tables creates an absolute path to the external tables. I would like to create relative path links to external tables so that if drive letters are changed, for example, it is not necessary to relink the tables using the Linked Table Manager.
|
| creating response card | 30 Dec 2005 08:20 GMT | 1 |
I have created my personal wedding invites and I am trying to take the one complete ready to print response card, and wondering how I make it two per 1 sheet. Works/Word Processor. Can someone help?
|
| electronic orders | 30 Dec 2005 05:14 GMT | 1 |
i'm student and i need to make database for electronic orders so i'm asking for help. what tables are needed and their relationships? tnx in advance --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =---------
|
| Access 2003, autonumbers | 30 Dec 2005 01:47 GMT | 21 |
I've been trying to design an Access database for my coin collection. I've been at it since 01, but that doesn't matter, does it. I can set the autonumber to work for the alternate country names, so filtering is easier. I'm having trouble being able to link the autonumber for ...
|
| Importing data in to an Access table. | 29 Dec 2005 23:24 GMT | 3 |
I am importing data from a linked table in to an Access table. I am using queries to do this. the Linked Table is named Source_Table the Access Table is named Target_Table
|