Things I’d like to be able to do, and I’m sure I could if I knew how to
formulate and run database queries on the sqlite database.
> On Oct 18, 2017, at 6:23 PM, Roger Oliver wrote:
>
> Are the queries in your second paragraph thinks you can do now or something
> we'd like to see? Thanks
>
>
Are the queries in your second paragraph thinks you can do now or something
we'd like to see? Thanks
On Oct 18, 2017 5:13 PM, "R. Victor Klassen" wrote:
> This seems like something that ought to be doable by the database-savvy
> among us. Especially if you have a database (sqlite) back end.
> U
This seems like something that ought to be doable by the database-savvy among
us. Especially if you have a database (sqlite) back end.
Unfortunately I’m not one of those. The information is certainly there.
Other useful queries along similar lines are “tell me, by customer, how much of
X was
Thanks. So I'm not losing my mind after all.
On Oct 18, 2017 2:13 PM, "Derek Atkins" wrote:
> Hi,
>
> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> > Is there a way to get a sales report by item? Total sales for a day by
> > item
> > for example. The only indicators I can find wou
I have no skills to write such report. If someone eventually does write
one, please let me know. It would be greatly appreciated.
At the moment we are doing the report manually.
On Wed, Oct 18, 2017 at 4:21 PM Derek Atkins wrote:
> Hi,
>
> On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wro
Hi,
On Wed, October 18, 2017 2:50 pm, rmom...@gmail.com wrote:
> Is there a way to get a sales report by item? Total sales for a day by
> item
> for example. The only indicators I can find would be the description field
> on the invoice or the income or other account credited for the sale.
> Thank