时间戳

首页 > 解决方案 > 在 MS Access 查询中过滤负余额

vba - 在 MS Access 查询中过滤负余额

问题描述

我创建了一个酒店预订数据库，其中有一个支付查询，其中我有总成本字段、总支付字段和余额字段，但我似乎可以过滤那些余额大于总支付的人。我需要根据预订创建债务人报告。

我打算对债务人进行排序的查询的 SQL 语句：

SELECT "Print" AS Print, "Make Payment" AS MakePayment, tblBookingPayments.BookingPaymentID, tblBookings.GuestID_FK, 
tblBookingPayments.Discount, CCur(DSum("[Amount]","qryCostsPaymentsUnion",
"[BookingID]=" & [BookingID] & " AND [Item]<>'" & "Payment" & "'")-([Discount])) AS TotalCost, 
CCur(DSum("[Amount]","qryCostsPaymentsUnion",
"[BookingID]=" & [BookingID] & " AND [Item]='" & "Payment" & "'")) AS TotalPaid, CCur([TotalPaid]-[TotalCost]) AS Balance, 
tblBookings.BookingID, tblBookingPayments.EmployeeID, tblBookingDetails.CheckInDate, 
tblBookingDetails.CheckOutDate
FROM (tblBookings INNER JOIN tblBookingDetails ON tblBookings.BookingID = tblBookingDetails.BookingID_FK) INNER JOIN 
tblBookingPayments ON tblBookings.BookingID = tblBookingPayments.BookingID_FK;

标签： vbams-access

解决方案

推荐阅读