Search results

I am attempting to make a text box on a report count the number of records that match the current Grouping and then display it. Currently, Speed is not my concern, I am dealing with a database that does so little it doesnt even really matter. I just want it to be easy, robust and repeatable...

I am attempting to take the current time and subtract another fields time and get a number of months in decimal format and then compare it to a range to set criteria for a query. How do I enter ((now()-[arrivaldate])/30.4)>=0 and make it see if that value is truely >=0 in months.

Does my issue stem from trying to find a range from 0 to 2 out of a date function?

=dcount is getting me a bunch of "0"s =IIf([afsc]="2a5x1","N/A", DCount("*","1-Primary Table","[phaseonereq]=Yes and [phaseonecomp]=0 and ((Now()-[arrivaldate])/30.4)>=0 and ((Now()-[arrivaldate])/30.4)<=2 and [phaseonestatus]='UNQAL'")) -->Criteria Changed Slightly

Thanks for the help, I'll let you know how it works. I go back into work tonight.

I'll take what I can get.... specially since this error is so obnoxious.

There is exactly 7 of each parenthesis. And it doesnt work without them. Especially since I want to subtract before I divide.

I have a report which counts values on a table in which it is grouped by a value on that table and I want to count specific ranges with in that table and show the numbers on the report. My instructor told me to use =Select count (select * from [table] where [req]=Yes and [comp]=0 and...

My programming instructor told me to use this for counting records in a report with multiple conditions; =Select count (select * from [table] where [req]=Yes and [comp]=0 and ((Now()-[arrivaldate])/30.4)>=0 and ((Now()-[arrivaldate])/30.4)<=4 and [status]="UNQAL") But when I enter it, I get...