Aggregate Query

[Lyncroft]

I've a query using the Totals feature which is counting the number of licences issued (column 2)to the actual number of licences available (column3)

SName CountofSname NoLic

Photoshop 6 5
Word 5 7


I need to run another query to show those records where the number of licences is greater then the countofsoftware eg, column 3 greater than column 2. Been mucking around for a while with this. Some sort of nested query perhaps?

Any ideas. Thanks

 

[dcx693]

I believe you can use your existing query, just use some critieria that says something like:>[countofsoftware] in the critieria for NoLic.

 

[Lyncroft]

Thanks for that. Yet another case of thinking so hard about it I missed the obvious