Search results

How can I modify table structures in a split app if I don't have the unsplit app ? I think I screwed up royally.

Ok - I got it. Thanks everyone

ok I got it with your help. SELECT Sum(TblPayments.Creditamt) AS SumOfCreditamt, Format([Recdate],"mmmm") AS AMonth, DatePart("yyyy",[Recdate]) AS AYear FROM TblPayments GROUP BY Format([Recdate],"mmmm"), DatePart("yyyy",[Recdate]), DatePart("m",[Recdate]) ORDER BY DatePart("m",[Recdate])...

Yes, like Jan, Feb, Mar, Apr. This doesn't do that, they are in alphabetical order. What I need is a monthly total with months in the correct order and a yearly total at the bottom.

Ok, this gives me the monthly totals but the months aren't in calendar order. How can I get them in that order ? SELECT Sum(TblPayments.Creditamt) AS SumOfCreditamt, Format([Recdate],"mmmm") AS Expr1 FROM TblPayments GROUP BY Format([Recdate],"mmmm");

Well I can use this running total for a year's total. Anyone got an idea how I can get monthly totals ?

Thanks Brian. However, I'm back to square one. I just realized this is NOT a monthly total like I want. I want a total BY MONTH then a total BY YEAR. Oh well, back to the drawing board.

around the expression ??

Heck, knew it would be simple. One more thing. Using this query in a report, I get no format choices in the field 'RunTot' so I can print / display it in currency format. Nor will it take a format, (that I can find) in the query layout. Any idea on that ?

Never mind, I found the problem. Left out the table name in the expression. However, would someone tell me how to get "FDate" in that query to print/display the whole month name rather than just the first 3 letters ? Or is that possible ?

Would someone be so kind as to tell me why I get Err in the Runtot field from this query ? It seems to run fine except no totals. SELECT DatePart("yyyy",[Recdate]) AS AYear, DatePart("m",[Recdate]) AS AMonth, DSum("Creditamt","DatePart('m', [Recdate])<=" & [AMonth] & " And DatePart('yyyy'...

Here is what I have now: SELECT TblCustInfo.CID, TblCustInfo.Name, Max(TblPayments.Recdate) AS MaxOfRecdate FROM TblCustInfo LEFT JOIN TblPayments ON TblCustInfo.CID = TblPayments.CID GROUP BY TblCustInfo.CID, TblCustInfo.Name HAVING (((Max(TblPayments.Recdate))<Date()-45 Or...

sql I think - from the query design.

I think the problem is what I am needing from two different tables PLUS a query to do what I need. TblCustInfo I need CID and Name TblPayments I need RecDate(from query) and Creditamt Then in a query or queries I need the LAST payment date (Recdate) 45 days or more ago - ONLY the last and...

tried that still shows ALL payments beyond 45 days

In fact, this shows ALL payment dates older than 45 days for each customer and does not list any with NO payments. I tried "Last" instead of Max but does the same thing. Any ideas how to list only the last payment and all non-payments ?

Thanks RuralGuy

I am opening a form from a form with a command button. The second form's default view is datasheet view but when I open with the button, it doesn't open in datasheet view. I am assuming I need to edit this on_click code somewhere ? Private Sub CmdBtnChargereasons_Click() On Error GoTo...

If I only have the Payments table open in the query, it won't show non-payments since they aren't there. I would have to also open the customer table and reference the CID in it. Correct ? Just tried it, it ONLY shows dates 45 days or older but does not list non-payments. Here is the sql...

I got to thinking about this and now have a question for opinions. Based on the above, this would be showing only actual received dates of payments that are 45 days or more old. What IF there was no payment at all by a customer ? Shouldn't that be listed also ? Opinions ?