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.

Taidot: Tietokannan hallinto, Tietokantakehitys, Tietokantaohjelmointi, Microsoft Access, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 14 arvostelua ) York, United Kingdom

Projektin tunnus: #18641322

Myönnetty käyttäjälle:


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 Lisää

£50 GBP 3 päivässä
(7 Arvostelua)

6 freelancers are bidding on average £71 for this job


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

£33 GBP 3 päivässä
(270 arvostelua)

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on I am ready to carry out your project in the reasonable price and in the shortest possibl Lisää

£50 GBP 1 päivässä
(164 arvostelua)

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. Lisää

£220 GBP 3 päivässä
(21 arvostelua)

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 Lisää

£50 GBP 2 päivässä
(19 arvostelua)

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 Lisää

£23 GBP 1 päivässä
(15 arvostelua)