Hello, So I have a table in which it contains multiple columns, one of the columns contains date. I'm using the following in the query builder to retrieve the data of the last month. month(date_field)=month(today())-1 AND year(date_field)=year(today()) Sometimes during the first few days of the new months, data of the previous month wouldn't be available so the query returns no results. I want to retrieve the data of 2 months ago if this happens. This can be done using the following query builder statements.  month(date_field)=month(today())-2 AND year(date_field)=year(today()) What I want to accomplish here is an automated process, in which if the first query fails to retrieve data the second query should run automatically. Any ideas? I've thought about running a query which returns new columns with these values month(max(date_field)) - year(max(date_field)) and use them in a third query which retrieve data. So i wouldn't need the 2 queries above, unfortunately i didn't know how  to compare the results with the origin table again. Thank you ... View more

Hello, So I have multiple tables with only one record in each one of them. I have another table which combines all the tables in one table. What i'm trying to do is to calculate a value from multiple tables (subtract and add) to then create a new column with the result. Your help is appreciated . ... View more