J
juan
Hello ,
I'm not sure that this is possible but just want to
confirm. I need to run a query by period base on our
company calendar. So currently, I run a query for each
period, and then Append in a table in the right Period. So
for the year I would have to do 12 queries. Ideally would
like to have following:
Field1, Field2, Period1,Period2, Period3 etc.
so in the criteria under date I put my date range. But if
I put under criteria for each period that I want it
doesn't get me anything. So I figure that I cannot use
more than one date in criteria. Any feedback would be
great.
Thanks,
Juan
I'm not sure that this is possible but just want to
confirm. I need to run a query by period base on our
company calendar. So currently, I run a query for each
period, and then Append in a table in the right Period. So
for the year I would have to do 12 queries. Ideally would
like to have following:
Field1, Field2, Period1,Period2, Period3 etc.
so in the criteria under date I put my date range. But if
I put under criteria for each period that I want it
doesn't get me anything. So I figure that I cannot use
more than one date in criteria. Any feedback would be
great.
Thanks,
Juan