Recent content by barrymungall1

I'm OK entering it when I open the report. Once it's open, I'd like a label defining what the report is. If I chose a date range of Sep 1 - Sep 8, I'd like the label to autopopulate with that date range. So the prompt is OK, just figuring out a way to input the prompt values into a label...

I think I've got it figured out. I used [ ] in my query, and it's working perfect now - it just prompts when I open the report, which is just fine with me. Is there a way to, based off of my inputs of the date when I open the report, to have a label somewhere on my report that auto populates...

I'll re-explain a bit better and hope there's an easy answer.. In my query, the first column is a dollar figure - I have the totals toggled, and have it summing the value. The next column is a unique primary key number. I have it counting these in the total. Next is a column with a true or...

Hi, I have a simple table with various values, one of which is a date/time stamp. I have a query, that references data from this table. My query Sum's a total dollar value of a field, and also counts the # of unique entries where a particular criteria is met (just a true/false criteria)...