创建Ytd和当前月份列 [英] Create Ytd And Current Month Columns
问题描述
我是新手，不吹嘘，但考虑到我没有对任何类型的计算机程序进行正式辅导，我对我取得的进展印象深刻。这对我来说都是试错。无论如何，我已经为我的工作创建了一个数据库。我很满意，但我被困在报告上。我有一张桌子：
字段：
客户ID
供应商名称
date
发票
销售
我需要有一份报告，列出每个客户和每个供应商的销售栏目，显示今年的年初至今，去年年初至今，今年莫，今年和本月。
我已经成功地进行了不同的查询，但似乎无法在一个查询中获取所有信息。我做了子报告的事情，但它显示了组中的信息。而不是直接：
ie：
I am new to this and not to brag, but I''m very impressed at the progress that I have made considering that I have NO formal tutoring on any kind of computer program. It has all be trial and error for me. Anyway, I have created a database for my work. I am satisfied with it except I am stuck on a report. I have a table with:
Fields:
customer id
vendor name
date
invoice
sales
I need to have a report that lists every customer and every vendor with sales columns that show YTD this year, YTD last year, Current Mo this year, and Current Month last year.
I have succeeded in making the different queries but cannot seem to get all of the information in one querie. I did the sub report thing, but it shows the information in "groups" instead of straight across:
i.e.:
推荐答案
你能发布已经存在的查询。
你能解释一下为什么显示两个ytd值吗？
Can you post the queries you have already.
Can you explain why there are two ytd values shown?
类似下面的内容应该是工作
假设表结构如下：
VendorName
SalesDate
SalesAmount
Something like the following should work
Assuming table structure as follows:
VendorName
SalesDate
SalesAmount
类似以下内容应该有效
假设表结构如下：
VendorName
SalesDate
SalesAmount
Something like the following should work
Assuming table structure as follows:
VendorName
SalesDate
SalesAmount
这篇关于创建Ytd和当前月份列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
