That was long ago. Do you want me to check on something for you. US is the normal format that one should use.
How and where did you pick up a problem. I Think yhere is more to this than meets the eye.
Also check Allen Brownes site, there is more to learn there.
Does someone want to...
What is this DSum for?
I think you need to post a copy of your Database.
What is the final result that you want. Is it the actual profit made or is it the average profit or is it something else.
Please explain the best you can.
If you use a Main form where you enter the Date and Stocktake.
In the Sub form link the two together via the Parent Child fields.
From here on as you enter a record into the Sub Form the Date and Stocktake get entered automatically. Do you understand? If not I will have to adjust the...
The simple answer is that they are different so store them differently.
I would think that you could come up with reasons to combine the tables but that simply creates surplus code.
Do you have something special on your mind other than what others are telling you.
A point of interest.
The Sum of the Tax on each order does not necessarily balance. It may be Dollars out. This is simply written off.
If you notice GST the Tax department always rounds this off to the nearest dollar.
Not sure what this means when you say a record drops off.
How does the user gain access to the Table, Query or whatever it is that allows them to delete or add a record.
Have you got any further information that may help.
Can we define the problem a little better.
If so are you satisfied that you can write an Inventory Control database then is your problem simply that you want a simple to use method that would give all locations their own identification that is not only unique but is also simple...