How to filter same data item

[bignadad]

I am trying to do a count of and id column [pps] to show me how many were created on a certain date.
I need to filter this data based on the date from 2 different columns. [date_pps] and [date_ship]



To create the table from the image I had each data item setup like so

PPS_PRINTED
if
([date_pps]=?prompt_date?)
then
([pps])
else null

PPS_SHIPPED
if
([date_ship]=?prompt_date?)
then
([pps])
else null

I then had to do the same for the PPS Lines.

It is working but is very slow and I feel its because I am not doing something obvious.
Is there a better way to do what I am trying to achieve?

[magicianer]

Another option would be to create two separate queries, one for 'print' and one for 'ship', then union them together. You would have to change how you calculate % shipped so it may or may not be that helpful.