Search results

I don't have the problem with it when running only the query. It is when I run the query through forms

Typo 300,000 records. It is a linked table so I don't have control of the table.

I have just one table with more than 300 records with queries set up. The queries are run from form date category and button with drop down to select category. Unfortunately, I keep getting the not responding message and hanging when running it although it completes it. Any suggestions or a way...

Nevermind. Figured it out. Had to convert the raw data to date format. Thanks so much. Saved me time.

Thanks looks logical. I keep getting an #Error though.

It is two different fields though doesn't list it [Date 1] and [Date 2] or [1/1/2015] to [11/2/2015]

Count the number of Months Between two dates Hello Does anybody know a query expression that will enable me to count the number of months between two dates fields. For example [1/1/2015] to [11/2/2015] is 11 months Thanks

Yes two seperate dates so I know I would need to calculate the amount of months

In need of help with the building of a query with the following criteria: Find out which members are still active for the entire year of 2015, field is either Active, Cancelled or Disenrolled If members were active**all of 2015 from*1/1/2015*to*12/31/2016*they get full amount which is 215.00...