从查询中创建表 [英] Make table from a query

问题描述

大家好，

我有一个输出ver_number的查询唯一字段和五个不同的日期字段（date1，date2，... date5）可以具有空值。

我想从这个查询中创建一个表格，其中包含ver_number。字段记录和每个ver_number的分配一个名为final_date的日期从这个顺序中的五个日期中选择：

final_date = date1如果为null则

final_date = date2如果为null则

final_date = date3等等on ...

如果所有五个日期都为空，则跳过此ver_number，不会添加到表中。

Hi All,
I have a query that outputs a "ver_number" unique field and five different date fields (date1, date2, ...date5) that can have null values.
I would like to make a table out of this query that takes the "ver_number" field records and assigns for each "ver_number" a date called "final_date" selected from the five dates in this order:
final_date=date1 if null then
final_date=date2 if null then
final_date=date3 and so on...
if all five dates are null then this ver_number is skipped and not added to the table.

推荐答案

大家好，

我有一个输出ver_number的查询唯一字段和五个不同的日期字段（date1，date2，... date5）可以具有空值。

我想从这个查询中创建一个表格，其中包含ver_number。字段记录和每个ver_number的分配一个名为final_date的日期从这个顺序中的五个日期中选择：

final_date = date1如果为null则

final_date = date2如果为null则

final_date = date3等等on ...

如果所有五个日期都为null，则跳过此ver_number并且不会将其添加到表中。

Hi All,
I have a query that outputs a "ver_number" unique field and five different date fields (date1, date2, ...date5) that can have null values.
I would like to make a table out of this query that takes the "ver_number" field records and assigns for each "ver_number" a date called "final_date" selected from the five dates in this order:
final_date=date1 if null then
final_date=date2 if null then
final_date=date3 and so on...
if all five dates are null then this ver_number is skipped and not added to the table.

尝试这样的事情......

Try something like this....

展开 | 选择 | 换行 | 行号

全部，

我有一个输出ver_number的查询唯一字段和五个不同的日期字段（date1，date2，... date5）可以具有空值。

我想从这个查询中创建一个表格，其中包含ver_number。字段记录和每个ver_number的分配一个名为final_date的日期从这个顺序中的五个日期中选择：

final_date = date1如果为null则

final_date = date2如果为null则

final_date = date3等等on ...

如果所有五个日期都为null，则跳过此ver_number并且不会将其添加到表中。

Hi All,
I have a query that outputs a "ver_number" unique field and five different date fields (date1, date2, ...date5) that can have null values.
I would like to make a table out of this query that takes the "ver_number" field records and assigns for each "ver_number" a date called "final_date" selected from the five dates in this order:
final_date=date1 if null then
final_date=date2 if null then
final_date=date3 and so on...
if all five dates are null then this ver_number is skipped and not added to the table.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

展开 | 选择 | Wrap | 行号

这篇关于从查询中创建表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！