•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 426,564 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,664 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 1100 | Replies: 0
 |
•
•
Join Date: Mar 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Automation design in a table I have one table, one field designates "TIME" in short form (00:00), the next field refers to this time to designate the "SHIFT" (A, B, or C). What I want the database to do is to AUTOMATICLLY input the shift letter that coralates with the time. A = 08:00 thru 16:00, B = 16:01 thru 24:00 and C = 00:01 thru 07:59 in the SHIFT field. Can this be done? And how? Is this a Query Action or a Macro? I am not a programmer, just trying to develop this database to help office so I need help in "plain english"
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Web design table woes (HTML and CSS)
- Help on General Best Practices for Table/Database Design (Database Design)
- Designing A Table (Visual Basic 4 / 5 / 6)
- Autonumber in a SQL Server table (MS SQL)
- Changing the datatype of a Column (MS SQL)
- Validation rule (Database Design)
- fan noise on boot (Cases, Fans and Power Supplies)
- SQL Injection Attack (Database Design)
Other Threads in the Database Design Forum
- Previous Thread: doubt in dbms
- Next Thread: Switchboard on top!
