Recent content by claine

Hi pr2-eugin Thank you for your help. I have figured my problem out using the same criteria I have mentioned above in another query. then using that query to link the results to the other queries. Charlotte

Thank you pr2-eugin I have manage to somewhat achieve what I want using Yrs left on Mortgage: [Years]-DateDiff("yyyy",[Submission Date],Date()) however, the query only returns the no of years back to 2011, and won't calculate any further than 2 years difference. Any ideas? Charlotte

Hello I have a submission date field and a no of years field. I want to create a query that returns a number of years but subtract the years that have already been: For example submission date = 28/11/2011 + no of years = 30, which works out to be 28/11/2041 but I also want the return to...

Thank you Brianwarnock I think I over complicate things sometimes as I tried > Date() to return the dates, which were still in date to give me the years remaining. Thank you for your help. Charlotte

Hello I am trying to create a parameter query to return dates that have 2 years remaining. For example I have dates for when mortgages expire, and I want to recognise the dates that have two years remaining using a parameter query but I can't figure out if I use DateAdd or DateDiff. Charlotte

Hi Brainwarnock I checked for dates that were not entered, and there were a couple so once I put in the dates, the parameter worked. Thank you for your help in solving my problem. Also thank you to namliam. Charlotte

Hi Brainwarnock I have notice that when I change the select in SQL to Parameters [min age] integer, [max age] integer, when I save and re-open, it changes to: Parameters [min age] Short, [max age] Short or Parameters [min age] Long, [max age] Long Is this something that can be fixed...

Thank you Brainwarnock I didn't realise you should never use Now(). I have taken this out now and use the code DateDiff("yyyy",[dob],date())+(Format([dob],"mm/dd")>Format(date(),"mm/dd"). In the criteria I have typed Between [Min Age] And [Max Age] and formatted the parameter to Integer...

Thank you namliam. Hi Brianwarnock I have a D O B field and created an Age field using: Age: DateDiff("yyyy",[D O B],Now())+Int(Format(Now(),"mmdd")<Format([D O B],"mmdd")) Now I have the age field calculated, I use the criteria: Between [Min age] And [Max age] but when I run the query, I...

Thank you namliam I have tested this and I am still getting problems so I have tried something else. I have now calculated the age in my client form, which works fine. Is there anyway I can add the unbound textbox I created to calculate the age in the form to my Client table? What I am...

Hi Chrafangau I have used the "Between [Minimum Age:] AND [Maximum Age:]" and it is showing an error 'data type mismatch in criteria expression. I have copied the query's SQL: SELECT CLIENT.[Client ID], CLIENT.Title, CLIENT.[Forename(s)], CLIENT.Surname, CLIENT.[D O B], Year(Now())-Year([D O...

Thank you Chrafangau. I believe this to be the criteria I need but I am still having problems: I have a D O B field so I created a Age field using Age: Year(Now())-Year([D O B]), which when run returns all the clients ages. However when I use the [Minimum Age:] AND [Maximum Age:] in the Age...

Hello I am using Access 2010. I've calculated the age of clients by creating a new field with Age: Year(Now())-Year([D O B]) but I cannot figure out how to use a parameter query to return the age of the clients between age 20 and 30, 30 and 40, 40 and 50 etc. Any tips? Charlotte

Hi All My name is Charlotte. I am a regular user of access but struggle sometimes. I look forward to helping others and being helped. :)