Hi ,
I am from Pakistan . Here each contract is made on 12 month basis , after that rent is increased 10% .
But tenants move during the dear the year and move in date is different for each .
What my idea was to run a query every month , which will counts the months and then add the increment...
Hi,
I am thinking that let say i have 4 tenants who joined during different months on 12 months contract, what if we continue and we agreed on 10% increment after 1 year .
How to control for each customer .
For Example Mr.A joined in month January , his rent will increased automatically in...
Dear @a.sharma
I have checked your test Database, Some questions I want to ask
When we already entered the CustomerName , Why we have through Voterid
Even we can do like CustomerName = txtfield
And then it directly go to Scanner page or File option etc.
and make the output file =...
I am attaching my database. I will like to tell why I want one form to record two tables
I have make this database to record the pending delivery stock of customers .
So we make input to show inputs of stock in warehouse
and then make bills for customers with quantity.
and make...
Actually both forms has two parts. Master and child form both linked. And I want to make a third form which then transfer the data to both of these forms. But still no good idea coming to my mind.
P.s I am not expert in Ms access
@Galaxiom Thanks for helping.
The purpose of two tables is due to some times on table is to be updated separately. That's why cant make single table with some fields in common . So do you think if two tables to be updated what should be done. Thanks
one update, if I have same information, if I have same information why I created two forms. it is because sometimes I only want to add entry in single table for which I can use another form.
Hi,
I have two tables , and I want to put the information from single form to two tables.
Just wanted the text boxes data to two different form, this I want to save the time to enter into two different tables .
For example
Date , Name , Productname.
This I want to put into...
Just for example the data as follows (output needed as below with your sql)
Product in out
APPLE 10 5
MANGO 10 0
if the table in as follows
Product In
Apple 5
Mango 5
Apple 5...
Thanks Galaxiom, i have tried your sql, it worked, but the results were not correct, It is showing the out column correct, but do not showing in column not correct, as it is multiplying it.