调度/跟踪在字节上找到的日历 [英] Scheduling/Tracking Calendar found on bytes
问题描述
大家好，
我从这个网站抓住了数据库患者并试图调整它。
我把tblPatients带到了EmployeeHours。这些字段现在是：员工，typeofleave，sumofnumofhrs，leavedatefrom，leavedateto
我添加了休假类型（以获取年度休假的出勤代码）
我拿了qryPatients并把它变成了qryEMP，所以现在我得到了与EmployeeHours相同的信息并添加了考勤代码。
Public Sub PopulateCalendar（）
WAS：
Hello All,
I''ve grabbed the db Patients from this website and am attempting to tweak it.
I took the tblPatients and made it into EmployeeHours. The fields are now: employee, typeofleave, sumofnumofhrs, leavedatefrom, leavedateto
I added types of leave (to get the attendance code like LA for annual leave)
I took the qryPatients and made it into qryEMP, so now I get the same info as the EmployeeHours with the addition of the attendance code.
Public Sub PopulateCalendar()
WAS:
推荐答案
您当前的SQL语句不会反映日期范围你需要，n amely [ leavedatefrom ]到[ leavedateto ]，但仅 [ leavedatefrom ]。您将需要 WHERE ... BETWEEN ... AND ...语句中的构造。
检测到的模糊名称很可能是SQL语句中的语法错误或字段错误名称。
抱歉，没有看到修改后的SQL语句。玩它一段时间，如果你仍然有问题，发送数据库无任何敏感数据（或根本没有数据，只有结构）作为帖子的附件。当我有机会时，我会看看它。这个数据库有很多方面可以解决，并且试图弄清问题的位置有时会变得很困难，至少对我来说是这样。
Your current SQL Statement will not reflect the Date Range that you need, namely [leavedatefrom] to [leavedateto], but only [leavedatefrom]. You will need the WHERE ... BETWEEN ... AND ... Construct in the Statement.
The Ambiguous name detected is more than likely a Syntax Error in the SQL Statement or a Field misnamed.
Sorry, did not see the modified SQL Statement. Play with it for awhile, and if you are still having problems send the DB void of any sensitive Data (or no Data at all, just the Structure) as an Attachment to a Post. When I get a chance I''ll have a look at it. There are simply so many areas to go wrong with this Database, and trying to figure out where the problem lies is sometimes vary difficult, at least for me.
感谢您的回复。我没有太多运气。附上了zip文件。
再次感谢你，
osmosisgg
Thank you for responding. I am not having much luck. The zip file is attached.
Thank you again,
osmosisgg
请给我一些时间让我为你看看。
Just give me some time so that I can look at it for you.
这篇关于调度/跟踪在字节上找到的日历的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
