Search results

Is there a way to make a field on a report visible or not depending on the current date?

Original poster here. I found the answer on another forum, and I thought I would post the solution here to help people searching on this problem. All month =Sum(IIf([DateTransaction]>DateSerial(Year(Date()),Month(Date())+1,0),[AmountDebit],0)) One day...

I have a table of transactions, some with past dates, some dated the current date, and some dated in the near future. On a report, I'm looking for a way to get four different sums using the transactions in the table, each sum based on the dates of the transactions. I need a sum of transactions...

Well, I've had mixed results. I appreciate your help on this so I hope you know I'm not trying to be thick headed here. I have set up some sample transactions for next month and set up a dummy report to pull the transactions depending on their dates. I've had luck with one to pull all...

OK, I have found how to get it to return all transactions up to and including the current month's: WHERE datetransaction<=DateSerial(Year(Date()),Month(Date()),31); where the 31 represents the date of the current month. Also I see how to query for transactions after a certain date of the...

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments). Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a...

I have a table of checking transactions. Some are past, some from today, and some are dated with future dates (such as recurring payments). Is there a way to set up a query that will exclude transactions that occur after upcoming paydays (1st and 15th) dynamically? For instance, if I have a...

I have a db that is a checkbook register. I use a field in each transaction record to tell whether the transaction is current or is a future transaction (if it is in the future then it doesn't yet affect my balance). For instance, if the item is not scheduled to be paid for two weeks (I...

In my Checkbook db, I'd like to have a report where one field is the sum of all debit transactions in a table and another field that is the sum of only the transactions that haven't cleared (they have no post date in their record). How can I do this?

Can I have a report that pulls from three different queries?

Thanks RV, but I think you might be mistaken about my situation. I use Automation to launch the database programmatically -- with this .vbs script: dim o set o=createobject ("Access.Application") o.automationsecurity=1 ' low. rem o.opencurrentdatabase "C:\Documents and Settings\A\My...

Hi, I have been using "fSetAccessWindow (SW_HIDDEN)" in the open event of my main switchboard to hide the grey Access screen from being visible behind forms, reports, etc in this db. But when I started using a .vbs script file to launch the db, the Access window stopped being hidden. (The reason...