• From: Ethiopia
  • Registered: 2019-09-15
  • Posts: 43

Topic: Daily sales

Feliz navidad all MVD users

Supplies are made to customers each day. To calculate daily sales, leftovers is subtracted from supplies at the end of the day. I have been able to do the supplies but the sales is my greatest headache. Thanks in advance for the help

  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: Daily sales

humblelion,

Are you having a problem trying to calculate the sales value or the quantity sold?

Are you using a calculated column to work out your sales?

On a clear disk you can seek forever
  • From: Ethiopia
  • Registered: 2019-09-15
  • Posts: 43

Re: Daily sales

CDB wrote:

humblelion,

Are you having a problem trying to calculate the sales value or the quantity sold?

Are you using a calculated column to work out your sales?

Thank you CDV for your response

Sales is determined by subtracting total amount of leftovers subtracted from daily supplies. I want pull the supplies I have made by date and subtract leftover from it to get the daily sales. Thank you

  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: Daily sales

Humblelion, 

I think for your purposes a lookup field is what you need, I'm not the best with databases as yet, so I could be wrong.

After you have calculated the daily sales, do you need to write that to the database or just calculate it everytime you access the database?

On a clear disk you can seek forever
  • CDB
  • Member
  • Offline
  • Registered: 2019-12-16
  • Posts: 370

Re: Daily sales

Here is a link to a topic which I think you could use to solve your question.

http://myvisualdatabase.com/forum/viewtopic.php?id=5471

On a clear disk you can seek forever