Can I solve this in query
I have customer that stay in hotel from example 01/09/2014 to 20/09/2014 and they paid for that some money. And I have customer that stay from 10/09/2014 to 24/09/2014. I need query that will split the money to every day from 01/09/2014 to 24/09/2014 to see for every...
I have records that can be use several times and they dont change and record that change everey time. I want to be able to copy all records but also to locked older records to prevent users to change them.
Can someone help me about that?
I just beging learning access and I have some problem with IIF function
IIf[Broj dana]<=20>=15,5,0,IIF[Broj dana]>=20,10,0))
I need something like this
If someone can help , please