Where

**RayMilhon** · 11-09-2011, 04:37 PM

It would be easier to assist if you included your data structure. Table names and field names and types.

**kwooten** · 11-10-2011, 09:08 AM

I think I got it now.. I didnt know I could use the same table twice and that seemed to work..

Now.. I have a created date (January 2011-November 2011). If I want to count only October 2011 entries. How do I set up the formula in the report?

**RuralGuy** · 11-10-2011, 09:13 AM

Just put the value in the Criteria row of that date field.

**kwooten** · 11-10-2011, 09:14 AM

I need all the months to calculate YTD

**RuralGuy** · 11-10-2011, 09:21 AM

I'm not sure you can do everything you want in just one query.

**kwooten** · 11-10-2011, 09:23 AM

I have built a crosstab query based off my 2nd query, built from the 1st. I think it is going to work because I will then have each month separated.. At least I hope it will.

**RuralGuy** · 11-10-2011, 09:30 AM

It sounds like you might be on the right track now.

Where

Thread Tools

Posting Permissions