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!

Pat

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:

Where
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...