"姓名"用于创建表查询 [英] "Name" for a Create table query
问题描述
大家好，请阅读
并感谢所有帖子
背景：我的任务是为员工创建假日数据库我的实验室，（所以期待更多的帖子）
我遇到了第一个障碍，
i希望有一张带有emplyee细节的表，并为每个员工创建一个新表，包括假日日期和ammounts等，所以我需要一个创建表查询来为每个员工创建一个全新的（不相关的查询）。
in 工作人员表有详细信息：
名称
dob
职称
工资
小时PW
假期权利
等
和假期表中：
假日ID
员工ID（链接到表格（每个会员都有自己的表格，所以这个字段总是填写相同的员工ID）
date
am
pm
所以我想为每个添加到数据库的员工创建这个假期表并使用StaffID为表命名，
这就是我被困的地方
如何使用creat table查询将其命名为staffid字段？
请帮助我....
i还希望能够从多个表交叉表（许多表（对于每个员工）来创建假期列表和计数和其他......这是可能的吗？我很抱歉希望如此，没有必要告诉我如何（只是）但是可以做到吗？
谢谢大家所以很多
希望有人可以提供帮助!!
（对不起这篇文章很抱歉！）
DAN
Hello to all that read
and thank you to all that post
Background: I have been tasked to create a holiday database for the employees in my lab, (so expect many more posts)
im stuck at the first hurdle,
i want to have a table with emplyee details, and to create a new table for each employee to include holiday dates and ammounts etc, so i need a create table query to creat a brand new (unrelated query) for each employee.
in the "staff" table there are the details:
name
dob
job title
salary
hours PW
holiday entitlement
and so on
and in the Holiday table:
Holiday id
staff id (to link, to table (each member has own table so this field is always filled with same staff id)
date
am
pm
so i want to create this holiday table for each employee added to the DB and Name the table using the StaffID,
which is where i am stuck
how can i use the creat table query to call it the staffid field??
please help me....
i also want to be able to crosstab from multiple tables (many many many tables (for each staff member) to create holiday lists and counts and whatever else... is this possible??? i flippin hope so, no need to tell me how (just yet) but can it be done??
thank you all so much
hope someone can help!!
(sorry for the massive post!)
DAN
推荐答案
这不是通常的设计。为什么每个员工需要一张不同的餐桌？通常你只有一个假期表并包含其中的所有员工。
That''s not the usual design for something like this. Why do you need a different table for each employee? Usually you just have one holiday table and include all the employees in it.
因为我认为这是编制数据的最简单方法，（现在我有了新的想法（可能是把想法当作自己））如果我放入一个会更新的员工ID列（表格会变得非常大而且所有的更改）但是那样的，
ok我的等级，我将测试2moro，但你能否告诉我如何更新查询输入范围之间的所有日期？
例如，选择假日日期从 - 到 - 结束日期我认为这将是整理数据的最简单方法，但我如何获得更新查询以输入日期在...之间。选择的那些??
到目前为止你的帮助
because i felt that would be the easiest way of compiling the data , (now i am having new thoughts (probly the sme thoughts as urself)) if i put in a staff id column that would update (the table would get very big wih all the changes) but so what,
ok im on ur level, i will have to test 2moro, but could you tell me how to make an update query input all the dates inbetween a range?
for example, "select holiday dates from - till - end date" i think that would be the easiest way to collate data but how can i get an update query to input dates "in between" those selected??
thnks for your help so far
返回两个值之间的记录的SQL语法是：
The SQL syntax for returning records between 2 values is:
这篇关于"姓名"用于创建表查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
