Search results

I have googled this and cannot find a solution. Does anyone have a function which returns the date of the last Friday in a month. Appreciate your assistance. Thanks

Arnellgp and All Firstly, apologies for my tardy reply. We have experienced major flooding and power outages for the past week and have only just got back on line! I have imported my own data into the table in your latest example and all works really well. Over the 11 years of data that I...

Thanks for your response. This is a graphic of what I am trying to do.

Thanks for your reply. Perhaps I didn't explain this properly. I am not looking to find elapsed time between the entry of records. What I am looking to do is determine the number of days between the occurrence of each event. This is a table which records daily rainfall and I am trying to...

I could use a report if that is easier but I am not sure what the functionality is that you refer to. Thanks

Ultimately, the data will appear on a form. Would that work also?

Hi All I am trying to calculate the elapsed time between 2 records in the same table. I have a table which records rainfall data per day. Obviously, not all days are recorded. I need to know the number of days between 2 rain records so basically this is the elapsed time between the latest...

Thanks both for your responses. Both of which will work as I need it. I was not aware of the choose function. This is far simpler than what I was attempting. Again, many thanks

Hi All I am trying to use the switch function in a query. The function I have created is: YTDBud: Switch(Month(Date())=1,[sumofJan]),(Month(Date()) =2,[sumofJan]+[SumofFeb] Where SumofJan and SumofFeb are fields in the query. YTDBud: Switch(Month(Date())=1 returns the correct value for...

Sorry. My mistake. It is an error in the query design which is returning a null. Apologies for troubling you.

The calculation is returning the zero result from the NZ rather than the total I am looking for from the query.

Hi Folks Could someone kindly help me with the syntax for the following? AccLYJan = Nz(DSum("SumofAmount", "QryExpensesSumByMonthYear", "ExpMonth = 'Jan' And ExpType = 'Accounting'"), 0) Both criteria are strings and I just cannot get it right! Many thanks

Hi All I have a budget application which includes two tables, Budget and Actual Data. There are various expense categories which are captured by month. The issue I have is on the form that displays Actual expenses V's Budget Expenses per month where the actual expenses have not been incurred...

Thank you so much for that. Perfect!

Hi I am developing a budget model. In one area there are 3 alternative approaches to calculating budget income for the year. It is one of these options that has me stumped. It works on a calculation of income per day (all days are the same) x the number of working days in each month. I found...

Thanks for that. Works perfectly and a lot easier then coding each field!!

Sorry Pat Bad choice of words in my question. My table is structured exactly as you state. I am just looking to see if there is a "Universal" refresh option after any field is updated. Thanks

Hi I have a continuous form which creates an income budget based on 12 fields - Jan thru Dec. Each month is totaled in the form footer. The fields can be edited. Is there a way to refresh the totals after any field is changed rather than having to put code in the after update event of each...

Thanks arnelgp Perfect for what I needed!

Hi all I have a Dsum calculation as follows: JanCofAct = Nz(DSum("[CostIncGST]", "QryStockOutThisYearForBudget", "[Grp] = 'Coffee' and MonthName = 'Jan'"), 0) I need to add a year criteria where MyYear (as an integer) is derived from a user input box when the form loads. So what I am trying...