MS-Access:合并下面两个表
IhavetwotablesinmyAccess-database.Theylooksomethinglikethis:访问数据库中有两个表。它们看起来是这样的:Table1+--------------+----------+----------+----------+|Kabelnummer|C...
MS-Access更新SQL不是空但是空白(!日期和数字字段!)
Ihaveafewcontrolsthatarenumberandshortdateformatinmytablesalsothedatecontrolsaremaskedtomm/dd/yyyy.Someofthefieldsthatareloadedintotheformareblankfrom...
MS-Access更新SQL不是空但是空白(!日期和数字字段!)
Ihaveafewcontrolsthatarenumberandshortdateformatinmytablesalsothedatecontrolsaremaskedtomm/dd/yyyy.Someofthefieldsthatareloadedintotheformareblankfrom...
MS-Access中的Delphi SQL subselect错误
I'musingDelphi7withADOcomponents,andMSAccess2003.TheSQLsentence我正在使用带有ADO组件的Delphi7和MSAccess2003.SQL语句SELECTCMCB.Name,(SELECTSUM(amount)FROMmovementMC...
MS-Access将SQL Server的datetime2字段视为TEXT
I'mupsizingmyapplicationfromMS-AccessFEandBEtoMS-AccessFEandSQLServerBE.IusedtheSSMAAccess"upsizing"tooltoconvertallthetablesfromAccesstoSQL,thenIlink...
MS-Access中的查询:格式化sql UPDATE代码中间的字段
Iamhavingyetanotherproblemwithmydatainms-access.我在ms-access中的数据还有另外一个问题。Basically,whati'mdoingisusingmultiplesqlstatementstopull,sort,andstaightupchan...
在MS-Access中使用Datetime插入SQL命令
IamtryingthefollowingqueryinMS-Access2007,butitfailsonthetimefield.我在MS-Access2007中尝试以下查询,但它在时间字段上失败。INSERTINTOLOG(EMPLOYEECODE,STATUSID,LOCATIONID,TI...
MS-Access:选择每个会计月的开始日期和日期
SQLnewbiehere.SoIhaveatablethatreadsSQL新手在这里。所以我有一张表可读start_date|end_date|fiscal_month|fiscal_year------------|------------|-----------------|--------...
如何在MS-Access表单中使用400个字段?
IunderstandthemaximumnumberoffieldsinaMS-Accessformis255.Isthereanywaytogetaroundthislimitation?我知道MS-Access表单中的最大字段数是255.有没有办法解决这个限制?Iamworkingwitham...
将MS-Access数据库转换为SQL脚本的工具
OurSoftwarePackageusesMS-AccessDatabase,thisdatabasehasbeenmodifiedmanytimes,so,it'sabitcomplicatedtojustseethefiles(relationshipbetweentablesaresmall...
使用RegEx和Replace在MS-Access中使用USPS缩写更新地址字段
I'mtryingtowriteaVBAfunctioninAccessthatreplaceswordsinanaddressfieldwiththestandardUnitedStatesPostalAbbreviations.Irealizethisisnevergoingtobeperfec...
条件过滤的MS-Access SQL困难
IhaveaqueryinMS-AccessthatIamtryingtopullsomevaluesbasedonacondition,thensumtheresults.我在MS-Access中有一个查询,我试图根据条件提取一些值,然后对结果求和。SELECTSchedulingLog.User...
将TSQL转换为MS-Access SQL
TSQL(asusedinMSSQLServer2000and2005)allowsmultipleJOINclauses,onerightaftertheother,nocommasorparenthesesneeded.TrythisinAccessanditthrowsafit:"Syntax...
是否将MS-Access升级为独立的MS-SQL-Server版本?
IamplanningtoupsizeanAccess2010databasetoaSQLServerversion11(thesearetheversionsIuseinthemoment).我计划将Access2010数据库升级为SQLServer版本11(这些是我目前使用的版本)。Iamfam...
Excel oledb连接到Ms-Access数据库锁访问数据库
IhaveanexcelspreadsheetthatconnectstoMS-Access2003databaseusingoledbconnection.WhenIrefreshthedatainspreadsheetandopenmyms-accessdatabaseitsaysdatabas...