Jump to content

How to create a report of comics by date entered?

Patrick O’Malley

Recommended Posts

I'm trying to generate a report sorted by the date the item was added to my database.   

My comic shop switched to a software that does not detail which comics from my pull-list are on a receipt.  I'm trying to find a way to know which comics were received on that invoice.

Old receipt:
Comic 1 - 3.99
Comic 2 - 3.99
Comic 3 - 7.99

New receipt:
3.99 Comic x 2 = 7.98
7.99 Comic x 1 = 7.99

Thanks for your help in advance!


Link to comment
Share on other sites

The best way to do this is to use one of the Custom Date fields (there are 2 fo them) and update it with the date you bought the items.

Then do a Find (or Advanced Find) to find the range of dates you are looking for. The Advanced Find could include the sorting.

For Advanced Find, use something like this:

I.CustomDate1 BETWEEN '2022-01-01' AND '2022-03-31'

Order By
I.CustomDate1 DESC

(If you want to sort in the opposite direction, leave out DESC)

If you just do a Find you will need to click on the column heading to sort the Custom Date column.

After that, select some or all of the rows, Right-click and from the pop-up menu select Quick Report.

Note: Quick Report is (I think) the only way to get a report sorted the way you want. Any of the standard reports will sort by Title/Issue nunber.

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...