Search results

Uh.... never even thought of that problem. Any idea or is it even possible to overcome this easily... or is it a complicated process to solve this issue Thanks for your time Steve and assistance

I have 3 input fields: - RentAmount ( Currency, entered by user ) - PaymentFrequency ( Drop down selection which is either Weekly or Monthly ) - MonthlyAmountDue ( Currency, calculated ) I would like to be able to have the 'MonthlyAmountDue' textbox automatically display the total...

Once agan Brian you have saved the day. Thanks a million for the help

I want to create a query that by entering a 'Location' and a specific time frame eg Jan 21- Dec 12 it will return the total amount paid/received on that Location during that time frame. (Enter a location Enter a beginning date Enter a end date And the query to return the 'Total Amount Paid'...

Thanks a million pbaldy, works perfect. I feel so stupid when an answer is right there in front of me. Thanks again for the help

Im trying to get a query working that will selected all properties that have no lease(vacant) I have tried countless ways but am unable to get it to return the correct results. Is it even possible from my two tables show below. :confused: Once again any assistance is greatly appreciated. :)...

:) That works perfectly - thank you so much for your help, I am very grateful. I do hope your wife's tests come back with good results. Thanks again for your help especially with the worries you have at the moment.

Thanks for your reply Brian and best wishes with a speedy recovery to your wife, i hope it nothing to serious that has her in hospital. Just to let you know, UPDATE tblLease INNER JOIN tblPayment ON tblLease.TenantID = tblPayment.TenantID SET tblPayment.PropertyID = [tblLease].[propertyid]...

Brian, i have tried converting the database to be compatible with your version. I tried ammending the relationship between Property and Payment but no luck. If you have some spare time could you take a look and lead me in the right direction before i have no hair left. Thanks Database has...

Damn it, just after seeing the the payments table is missing all the property Id's How the hell :eek:

Thanks for your reply i have just double checked them again and they are PropertyTable - PropertyID - Autonumber PaymentTable - PropertyID - Number One to Many relationship - From property to payment table Any more light that you can shed is appreciated

I removed the "where" clause and it still gives me blank results. I have propertyId in the payment tables it is the fk. I even tried simplfying the code as below and it still giving a blank result:confused: SELECT tblProperty.Address, tblPayment.AmountPaid FROM tblProperty INNER JOIN...

I want to enter a location and get the total rent for that location. My SQL is as follows: SELECT tblProperty.Address, tblPayment.AmountDue FROM tblProperty INNER JOIN tblPayment ON tblProperty.PropertyID = tblPayment.PropertyID WHERE (((tblProperty.Address) Like "*" & [Enter Location:] &...

Thank you Brian for the explanation :)

Can someone be kind enough to explain (in simple terms) what exactly the following is doing. SELECT Lease.* FROM Lease WHERE (((Lease.EndDate) Between Date() And Date()+45)); Sorry for my stupidity :confused: Thank you for taking the time to read this :)

Thanks a million Trevor going checking it out now. Sorry for the late reply, been busy the last few days. Thanks again for helping out

;) Thank you

Can you post up a good resource on normalization please vbaInet that you would recommend, i dont think you gave me a link before for it, thank you.

I know vbaInet's and your advice Trevor G is priceless and is greatly appreciated, but for someone as stupid as me, i cannot take advantage of it. I have some design changes and relationship changes in attempt to get it working but more than likely i have made it worse. I cannot see any vote...

The two forms i created seperately, then drag-and-drop the datasheet view one onto the single form. The relationships i have them now as: