Microsoft access trouble shooting

I am creating a small database to use for my clinical audit data collection analysis.

I have created the main data table.

Created a simple query

The table contains date of birth field and date patient seen.

DateDiff function used to calculate Age in the query.

The Age field works ok in the query.

However this fails to insert in the table.

If I manually enter data in the query it inserts ok. But the DateDiff won't insert into table.

Will need some help with other functions too.

Квалификация: Управление базами данных, Разработка баз данных, Программирование баз данных, Microsoft Access, SQL

Показать больше microsoft access search function code, environment microsoft access function, microsoft access database search function, problems with microsoft access, disadvantages of microsoft access, microsoft access problems and solutions, microsoft access email function, microsoft access mail functions, find function microsoft access, microsoft access search function name, searh function microsoft access, basic search function microsoft access, email functions microsoft access, microsoft access function, using search function microsoft access, search function microsoft access coding, adding search function microsoft access database, search function microsoft access

О работодателе:
( 12 отзыв(-а, -ов) ) York, United Kingdom

ID проекта: #18641322



Hi, This seems like an easy job send me the file to look at I am a professional Access developer I have done many projects in Access have a look at my profile. I have a very good command over SQL and user interface Больше

£50 GBP за 3 дней(-я)
(6 отзывов(-а))

8 фрилансеров(-а) в среднем готовы выполнить эту работу за £96


Hi! It should be easy to solve. Can you share your database with me, please? Regards, Branislav Mihaljev

£33 GBP за 3 дней(-я)
(240 отзывов(-а))

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Больше

£50 GBP за 1 день
(125 отзывов(-а))

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Больше

£220 GBP за 3 дней(-я)
(15 отзывов(-а))

Greetings, I am interested in doing this job. I am BS-CS graduate and knows Database programming as well, because of which I can do this task with ease. Have worked on Orcale, MS- Access and MySQL. Hopefully we Больше

£50 GBP за 2 дней(-я)
(17 отзывов(-а))

Hi, I have 7 years of work experience with Access and SQL. I understand that you are looking for the query to be modified in a way where it can insert into a table. I can deliver it in a couple of hours. Can I pleas Больше

£23 GBP за 1 день
(15 отзывов(-а))

Dear Client! It's no problem and easy for me. I can do it best for you at fit price. Please send me a message and discuss more in detail. Regards.

£222 GBP за 1 день
(0 отзывов(-а))

Hi, I've read your job description very carefully. I'm a talented Database engineer with 5 years experience. At that time, I developed various DB projects based on MySQL, SQLite, MongoDB. Access Db. So I have rich Больше

£120 GBP за 3 дней(-я)
(0 отзывов(-а))