Recent content by sara27

Hi Does anyone know if it possible to create an email merge for a table that has two email fields for each record. My table has Email 1 and Email 2 where students have an email for one parent and another for the other parent. I would like to send emails to both parents. Can it be done or do I...

OK I have found a solution - as I didn't actually need the date to show anywhere I just needed to show length of service at the point of leaving or todate I have included date() in the equation thus =IIf([Date Of Leaving]<Date()," " & Int(DateDiff('m',[Forms]![Staff List]![Date of...

Would an update query ensure that the date will change each day as this is what I need as I am calculating the length of service todate. Thanks :)

OK I see what is happening - didn't think to look at the end of my table doh. New records are showing todays date but previous records are not - how can I get them to show todays date without having to re-enter all of them one by one? Thanks :)

I did that but it is not showing anything in the dataset view! I would expect it to show todays date where I have not put a specific date. Thanks

Could anyone explain why when I set the default value in a DATE/TIME field to Date() it doesn't show anything? Do I need to have any specific add-ins for this to work. Thank you:)

Hi Hope you can help. I have a table which I display in a form. The table has two Date/Time fields. In one field I can input and display in UK format no problem but the other field although it displays in UK format I have to input it in US style (month/day/year) Both fields were created at the...

Yes I think a combo box would be the best solution. I will do a mock up and see how it will work Thanks for your hel[p Sara

I think I will have to have separate fields for each condition as I don't see any other way. My problem was how to make it easier for user input (I'm going to be using the database in a VB application. If anyone has any other ideas please let me know :) Sara

I have looked at descriptions of normalisation but I'm not sure if I'm understanding your point. Are you suggesting I should create a table for Requirements and Tolerances? Perhaps if I explain a bit better what I'm attempting to do. I have a plant database. I have a table for each category of...

Hi, newbie question I have a field, Requirements and Tolerances but I need this fild to have 5 sub-fields - Water, Light, Wind, Salinity and Drought. How do I do this if it is possible. Thanks Sara