Hello Experts,
Not sure if this is possible. I need to open a report with 2 conditions. I have a Form that has a combo box (BarMonCombo) with all Months listed. Then I have a button which has the client name, when user selects month and client name the report for the selected month for that client is generated.
I can make it work with the client name only.
In my query, I have a field LastUpdate which is a date. In the query I have used the Month Name function. Expr: LUMName. Can we not check the BarMonCombo =LUMName as 2nd condition ?
SQL below.
SELECT BARPOList2QRY.ProjectID, BARPOList2QRY.ProjectTitle, BARReportDirectInvoiceQRY.DocumentType, BARPOList2QRY.MemberName, BARReportDirectInvoiceQRY.FundingAmount, BARPOList2QRY.[Payment Schedule Type], BARPOList2QRY.TotalMilestones, BARPOList2QRY.POStatus, BARPOList2QRY.MemberPORecvdDate, BARPOList2QRY.MemberPONum, BARPOList2QRY.MemPOAmt, BARReportDirectInvoiceQRY.PaymentOptionType, BARReportDirectInvoiceQRY.COGInvoicedSchDate, BARReportDirectInvoiceQRY.COGInvoiceNum, BARReportDirectInvoiceQRY.COGInvIssdDate, BARReportDirectInvoiceQRY.COGInvAmt, BARPOList2QRY.Notes, BARPOList2QRY.ActionOn, BARReportDirectInvoiceQRY.Notes, BARReportDirectInvoiceQRY.ActionOn, BARReportDirectInvoiceQRY.LastUpdate, Month([BARReportDirectInvoiceQRY].[LastUpdate]) AS LUMonth, MonthName([LUMonth]) AS LUMName
FROM BARPOList2QRY INNER JOIN BARReportDirectInvoiceQRY ON (BARPOList2QRY.MemberName = BARReportDirectInvoiceQRY.MemberName) AND (BARPOList2QRY.DocumentType = BARReportDirectInvoiceQRY.DocumentType) AND (BARPOList2QRY.ProjectID = BARReportDirectInvoiceQRY.ProjectID);
Please advise.
Thanks
Taruna
Not sure if this is possible. I need to open a report with 2 conditions. I have a Form that has a combo box (BarMonCombo) with all Months listed. Then I have a button which has the client name, when user selects month and client name the report for the selected month for that client is generated.
I can make it work with the client name only.
In my query, I have a field LastUpdate which is a date. In the query I have used the Month Name function. Expr: LUMName. Can we not check the BarMonCombo =LUMName as 2nd condition ?
SQL below.
SELECT BARPOList2QRY.ProjectID, BARPOList2QRY.ProjectTitle, BARReportDirectInvoiceQRY.DocumentType, BARPOList2QRY.MemberName, BARReportDirectInvoiceQRY.FundingAmount, BARPOList2QRY.[Payment Schedule Type], BARPOList2QRY.TotalMilestones, BARPOList2QRY.POStatus, BARPOList2QRY.MemberPORecvdDate, BARPOList2QRY.MemberPONum, BARPOList2QRY.MemPOAmt, BARReportDirectInvoiceQRY.PaymentOptionType, BARReportDirectInvoiceQRY.COGInvoicedSchDate, BARReportDirectInvoiceQRY.COGInvoiceNum, BARReportDirectInvoiceQRY.COGInvIssdDate, BARReportDirectInvoiceQRY.COGInvAmt, BARPOList2QRY.Notes, BARPOList2QRY.ActionOn, BARReportDirectInvoiceQRY.Notes, BARReportDirectInvoiceQRY.ActionOn, BARReportDirectInvoiceQRY.LastUpdate, Month([BARReportDirectInvoiceQRY].[LastUpdate]) AS LUMonth, MonthName([LUMonth]) AS LUMName
FROM BARPOList2QRY INNER JOIN BARReportDirectInvoiceQRY ON (BARPOList2QRY.MemberName = BARReportDirectInvoiceQRY.MemberName) AND (BARPOList2QRY.DocumentType = BARReportDirectInvoiceQRY.DocumentType) AND (BARPOList2QRY.ProjectID = BARReportDirectInvoiceQRY.ProjectID);
Please advise.
Thanks
Taruna