QX - Formula for Query Software

  • Thread starter Thread starter FYIS.org/
  • Start date Start date
F

FYIS.org/

Let's say that Bob has a general store and has several items that he
sells for $1.01 apiece. Now at the end of the year, he wants to know
which items he sold at $1.01 AND he wants to know the first time
(date) he sold that particular item.

Now, a customer knows how to do this the long way, but in his case it's
going to
breech the 64K record threshold that the output can handle, so what he
wants to be able to do is put in a formula in the output that only gives the
"min"
so that each item that sold for $1.01 comes up in one
instance and the earliest time.

He did this a long time ago so I know that it can be done, but his
memory isn't what it use to be.

DanlK
 
Let's say that Bob has a general store and has several items that he
sells for $1.01 apiece. Now at the end of the year, he wants to know
which items he sold at $1.01 AND he wants to know the first time
(date) he sold that particular item.

Now, a customer knows how to do this the long way, but in his case it's
going to
breech the 64K record threshold that the output can handle, so what he
wants to be able to do is put in a formula in the output that only gives the
"min"
so that each item that sold for $1.01 comes up in one
instance and the earliest time.

He did this a long time ago so I know that it can be done, but his
memory isn't what it use to be.
Click to expand...

This is being stored someplace? A database? Store the date if
there's no date stored for that item. That'll store the first sell
date for each item.
 
Back
Top