Very much appreciate it.
Another question if you or anyone would be so kind...
Do you know of a line command in SQL that I would be able to calculate something based on conditional logic of another record?
For instance... let's say I have four fields in a record: apples, peaches, pears and bananas.
Based on a quantity of greater than 0 in two fields, I would want to calculate the quantity and also based on the quantity of the record immediately following. Do you know of a command that would make that possible? Obviously there are IF functions that probably accommodate this, but I'm still learning so I don't know what they might be LOL
I realize that might be a difficult question to answer, but it's worth a shot!