Search results

After much hair loss and a long night i finally got it working With unmatched query wizard an a addition of an extra field in my payments form :D

Ok i got it working a little better with this code SELECT DISTINCT Query1.FirstName, Query1.LastName, tblPayment.DatePaid, Query1.DayOfPayment FROM Query1, (tblTenant INNER JOIN tblLease ON tblTenant.TenantID = tblLease.TenantID) INNER JOIN tblPayment ON tblTenant.TenantID = tblPayment.TenantID...

I have with fantastic help from John Big Booty created a query that lists all tenants that are due to pay rent for today. Supposing my query returns 3 results that are due payment. I check my bank records and see only 2 of these results are true. I want to be able to run another query that...

Thanks John for the reply, but that is way over my head. Any easier way to overcome this, i dont even know where to start :confused:

John, your going to kill me. I just had a thought. I have another problem, i am only going to run this query Monday thru Friday, but how am i going to pick up the tenants that are due to make payments if there payment day happens to fall on a Saturday or Sunday. Any help once again is GREATLY...

Oops, i got it working.... Thanks a million John for all the advice, and your patience. I added to your reputation :)

SELECT tblTenant.FirstName, tblTenant.LastName, tblLease.RentAmount, tblLease.PaymentFrequency, tblLease.MonthlyRentDue, tblLease.DayOfPayment, tblLease.CurrentTenant FROM tblTenant INNER JOIN tblLease ON tblTenant.TenantID = tblLease.TenantID WHERE (((tblLease.CurrentTenant)=Yes)) and...

I want to be able to get a list of all Tenant that are due to pay today. So if i have say 20 tenants that agreed to pay on the 30th of every month, when i run my query it will list just them 20 tenants

I could have sworn i done that and it gave me an error, but now it seems to be working fine..... Thank for your time and patience John. So now i create a query with the DateDiff to compare the dates, or am i wrong

Well i have my textbox added as a number field, user can enter a number <32 Im not sure how or where i go about converting this number to a date using DateSerial. My knowledge is very limited and along with my stupidity it makes it more difficult :confused:

Not able to get to grasp with this :(, sorry John

Thanks John for taking the time to reply and give advice, but im still not sure how i would use datediff.... I edited my original post with more info to my prediciment: EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so this would mean the tenant would pay his...

I want to add a textbox field to my Lease table that will contain the date that each tenant would like to pay their rent, so that each day I would be able to run a query to check who owes rent for that day. EG: The textbox field will only contain a single number beteeen 1 and 31, eg: 15 (so...

Can someone show me an example or sample code of how to cleanly cancel a macro. I dont want the Macro single step message box ( stop all macros etc... from showing) if i hit 'cancel' half way through running it

Thanks for the reply SOS appreciate your time for looking into it for me. Looks like i got to redo a lot of queries now as well. :(

Having problems when i delete a record from my tenants table. Two tables one property to many tenants is my relationship with enforced referential integrity ticked and cascade update ticked and i took the cascade delete off. Problem: When I delete a tenant from tenant table it is also deleting...

Thanks for that I got it working and thanks for advice as well.

Craig thank you for time and assistance. I tried to change my DB to match your settings but it still miss calculating the weekly amount I attached the DB with test info, so if you get some spare time i would appreciate if you could take a quick look. If you go to 'New Lease Details Form' -...

I have 3 text boxes in a form - Rent Amount is user input field - Payment frequency is dropdown combo box with weekly rent or monthly rent - Monthly Rent Due - is calculation field with this formula =[RentAmount]*Switch([PaymentFrequency]="Monthly Rent",1,[PaymentFrequency]="Weekly Rent",13/3...

Hi Thanks for all your replies and help, it is greatly appreciated. The formula below works for our requirements but i would like it dispaly a currency value. I did change the properties (format) to currency but its still not displaying it as a currency just a figure...