根据报告时间查找班次值 [英] find shift value based on time for report

问题描述

我正在运行一个基于表的报告，其中以这种格式输入时间HHMMSS，我想要做的就是查看当时的访问时间，而不是将时间放在我想要替换的报告上有一个字符串名称的时间，即墓地，白班等等有没有办法比较，然后用适当的字符串替换？

I am running a report based on a table where the time has been entered in this format HHMMSS and what I want to do is have access look at the time then instead of placing the time on the report I would like it to replace the time with a string name i.e. graveyard, day shift etc. is there a way to have it compare and then replace with the appropriate string ?

推荐答案

你必须创建包含要在一天中的每个时间对应显示的时间字符串的表，并在报告中使用该表。

You have to create a table with the Time String you want to display corresponding to each time of the day, and use that table in your report.

Imnew，

$ b $嗯，你的意思是我必须每小时每分钟创建一个表格并指定一个班次到那个秒，分钟，小时？


i希望这样的东西 - 我的表中的列有093025，当我运行我的报告时，我希望用Day Shift替换号码而不是数字 - 但我希望能够查看查询并仍然看到实际的数字 - 我只是想在报告中将其替换为


，即在列标题下是Time Created。并且该列包含上述数字 - 我需要根据查询中的数字用相应的班次替换数字


这有意义吗？

Imnew,

hmmm, you mean I have to create a table with every sec of every min of every hour and assign a shift to that second, min, hr ?

i was hoping for something like this - column in my table has 093025 and when I run my report I would like the number to be replaced with Day Shift and not the number - but i want to be able to look at the query and still see the actual number - i just want it to be replaced on the report

ie under the column heading it is "Time Created" and the column contains the numbers as above - i need to replace the number with the corresponding shift based on the number in the query

does this make sense ?

Imnew，


嗯，你的意思是我必须每小时每分钟创建一个表格指定一个转移到那一秒，分钟，小时？


i希望这样的事情 - 我的表中的列有093025，当我运行我的报告时，我想要更换这个号码与白班而不是数字 - 但我希望能够查看查询并仍然看到实际的数字 - 我只是想在报告中将其替换


即标题为创建时间的列。并且该列包含上述数字 - 我需要根据查询中的数字将数字替换为相应的班次


这有意义吗？

Imnew,

hmmm, you mean I have to create a table with every sec of every min of every hour and assign a shift to that second, min, hr ?

i was hoping for something like this - column in my table has 093025 and when I run my report I would like the number to be replaced with Day Shift and not the number - but i want to be able to look at the query and still see the actual number - i just want it to be replaced on the report

ie under the column heading it is "Time Created" and the column contains the numbers as above - i need to replace the number with the corresponding shift based on the number in the query

does this make sense ?

Plz，澄清替换中使用的逻辑。

如果可以通过多个比较实现，您可以在报告查询或报告字段中使用切换功能或嵌套的IIf函数。

Plz, clarify the logic used in replace.
If it can be implemented by several comparissons you may use Switch function or nested IIf function in report query or in report field.

这篇关于根据报告时间查找班次值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！