访问2个字段 [英] Access 2 fields

问题描述

我有多个字段的记录。

字段扩展为5位

字段交换需要根据扩展的值填写


如果分机是60000到69999，那么交易所应该显示85-

如果分机是41000到41999那么交易所应该显示33-


因为我正在寻找的价值之间我有问题



先谢谢你

I have records with multiple fields.
Field Extension is 5 digits
Field Exchange Needs to be filled out depending of the value of Extension

If Extension is 60000 thru 69999 then Exchange should show 85-

If Extension is 41000 thru 41999 then Exchange should show 33-

I am having a problem because of the between value that I am looking for



Thank you in Advance

推荐答案

我担心这个问题不完整。

请重新说明，以便我们掌握所有信息。我们可以尝试帮助解答，但写一个有意义的问题是你的工作。


MODERATOR。

I''m afraid this question is incomplete.
Please rephrase it so that we have all the information. We can try to help with the answers but writing a question that makes sense is your job.

MODERATOR.

展开 | 选择 | Wrap | 行号

展开 | 选择 | 换行 | 行号

这篇关于访问2个字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！