Search results

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

Anybody suggest me how I should do

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...

I am again attaching the file.

The file is attached in Post #11 test.accdb

Any solution will be appreciated

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.

Sorry for that. I will correct it. But can you suggest me what I can do for the solution

Brother all I can say I can take photos thus you can understand my point.. I have even tried with table field nz not working. Surely some mistake from my side

Only the product which have entry in out table are showing else the product only in out or in table not showing

Still not working dear friend

SELECT Product.Product, Nz(DSum("quantityin","in","product=" & [auto]),0) AS Expr1, Nz(DSum("quantityout","out","product=" & [auto]),0) AS Expr2 FROM (Product INNER JOIN [In] ON Product.auto = [In].Product) INNER JOIN Out ON Product.auto = Out.Product;

Is there anyway I can assure you that file is safe? Anyway I am posting SQL view hope you can understand