帮助编写多表查询 [英] help writing a multiple table query
问题描述
我真的需要一些方向在这里写一个查询。
我提供了一个屏幕上限，这样你就可以抓住漂移。
http://www.mykesdesigns.com/tblrock1...s/terminfo.jpg
你可能会看到有很多桌子。有58个表几乎与显示的表相同...
每个表代表一个txt文件，每晚导入我们的服务器，每个txt文件是一个商店。这些文件包含有关终端的信息..
每天我筛选相同的60个文件，并确保在角色字段中将TermName字段中的＃2设置为备份并且没有其他条款在该领域中有角色备份。
我真的很想知道如何使查询输出REDFLAG的方向。如果你愿意，指出一张桌子不是应该的样子。
我希望这是有道理的。我会解释任何人都想要的更好的事情。
提前多谢！
I really need some direction writing a query here.
I provided a screen cap so you may catch the drift.
http://www.mykesdesigns.com/tblrock1...s/terminfo.jpg
as you may see there are a ton of tables. there are 58 tables that are all nearly identical to the one shown...
each table represents a txt file that is imported every night to our server and each txt file is a store. These files hold the info about the terminals..
Every day I sift through these same 60 files and look to make sure #2 in the TermName field is set to Backup in the Role field, and also that no other Terms have the Role backup in the field.
I would really love some direction to take on how to make a query output a "REDFLAG" if you will, pointing out that a sertain table is not how it should be.
I hope this makes sense. Ill explain anything better that anyone wants me to.
Thanks a ton in advance!
推荐答案
最好是创建一个处理所有表并执行所需检查的函数。您是否能够/愿意使用VBA代码？
是否需要备份角色测试，或者您是否将数据用于更多？
Nic; o）
It would be best to create a function that processes all tables and performs the checks needed. Are you able/willing to use VBA code ?
Is the Backup-role test all that''s needed, or do you use the data for more ?
Nic;o)
最好创建一个处理所有表并执行所需检查的函数。您是否能够/愿意使用VBA代码？
是否需要备份角色测试，或者您是否将数据用于更多？
Nic; o）
It would be best to create a function that processes all tables and performs the checks needed. Are you able/willing to use VBA code ?
Is the Backup-role test all that''s needed, or do you use the data for more ?
Nic;o)
heyy我愿意做任何必要的事情，数据库只用于此功能。
有时这些位置有两个终端设置为备份，有时它们没有备份。
我需要它能够运行它并让它返回任何不是应该如何，所以我可以给他们发电子邮件，告诉他们解决它。是否他们备份了两个终端或备份没有终端。
如果有帮助，我甚至会在互联网上发布这个数据库...
请回复我！
谢谢！
heyy I would be willing to whatever is necessary, the database is only being used for this function.
Sometimes these locations have two terminals set as backup, and sometimes they dont have a backup.
what I need it to be able to run it and have it return anything that is not how it should be so I can email them and tell them to fix it. whether that be they have two terminals on back up or none on backup.
Ill even post this database on the internet if that helps...
Please get back to me!
thank you!
没有必要，这个功能并不难。
No need, the function isn''t that hard.
这篇关于帮助编写多表查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
