Search results

SELECT qryAllTransactionsMTLSide.* FROM qryAllTransactionsMTLSide UNION ALL SELECT qryAllTransactionsRoFSide.* FROM qryAllTransactionsRoFSide; Worked for my first issue, now need to join ID's, and I forgot to mention I need to have a field that displays the field [MTLDateCompleted] if...

Hey all, So I have two tables, tblMultipleTransactionLogs, and tblReceiptofFunds - they are both two types of transactions we do, therefore stored and normalized. The common field among them is the [Patron], which is a number field related to [tblPatrons.PatronID]. Both have some unique...

Tried this and it worked, cheers!

Here is the results of both, the third collum is the solution I came up with. This isn't a big deal at all, but is a mystery to me!

Hey there, mine is like that as well, but still no luck - it is pulling from a Sum on another query, could that cause this?

I've tried that with no luck, my solution was TotalFormatted: Format([Total],"Currency") Not sure why this didn't work in the property sheet?

One last question about this, how would I format it as currency from the query, the field on the form is formatted but does not show the $ like the one beside it that is Unbound and DefaultValue = 0? EDIT: Format(NAME,"Currency") worked!

Absolute genius you are. Thank you very much!

Hey arnelgp! Thanks for coming to my rescue again. I've done this, and it works kind of - I'll attach a screenshot below and the code Select PatronID, SumOfTotal From qryTransactionsExtendedAmountSum ORDER BY 1 UNION SELECT TOP 1 0, 0 FROM tblPatrons ORDER BY 1; The issue is that it only...

=Nz([SumOfTotal],"0") Could something like this fix the issue on the form? The main issue is that again, if there is no PatronID in the query, It results in zero. Just brainstorming, not sure how to proceed! UPDATE: Does not work, as I mentioned it all comes down to no PatronID to link it to...

Hey all, Not sure how to title this, as I'm not sure what to even call this. Essentially the database I'm building is for transaction records, the query in question totals the transactions and sums them for each person. I'll attach a screenshot below. ---------------- The query...

Hey plog it appears you're a genius and I thank you very much! I'll mark as solved and hope someone down the line finds this to help them too!

Thank you, I'll try this and report back!

Between #2/5/2006 14:7:0# And #11/18/2006 17:28:15# I found this example online, but I want it to be Date() and Date() +1 with 4AM and 3:59AM This code works, but doesn't display the record I'd want

Saying invalid syntax, operand without an operator?

Date() 04:00am# and Date()+1 03:59am (the basic needs) this is what I've come up with so far Between #Date() 04:0:0# And #Date() +1 03:59:0#

Hey All! I have a query that I am trying to run that'll populate a chart showing transactions from one period to another within the "day". Essentially, in our business we have a time period which transactions "reset" a threshold. At 4AM every day I need to clear the query and begin only...

Thank you so much, I am not sure why it did not work me when I did, I've copies over the contents and will rename as needed!

Hey there, Thanks for your code, I tried this and it worked, the issue is I have been unable to re-enable it with a button. Any ideas?

Hey there, I've tried adding this too, but it just freezes my database and doesn't change the property. Not sure where to go from here?