In a simple database I get the error message "type mismatch in expression" each time I attempt to run a report. I tried to attach the database to this thread but it says invalid file. It appears that access file are not valid file extensions for this forum? It is not a friendly access evening for me. Any suggestions on resolving the error would be appreciated.
Last edited by Juli; 04-20-2019 at 11:46 PM. Reason: Title not correct format-corrected
Sanitize your file so that there is no sensitive information. Run a compact and repair. Zip the file and then upload it. Remember, we do not need 100% of the data, only a representative amount to show what is happening.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Thank You Alan- It appears the file is now attached.
Your issues are the relationships. In your query you are linking Patients First Name with the Provider, the Nurse First Name with the date admitted. This needs to be resolved to get the correct relationships established. Look at all your relationships and fix them so that they make sense. You have mismatched names and numbers (ID). This all need to be consistently applied. I have not listed all the issues, just the general scheme in the relationships. Your queries need to work for the reports to work as they are the record source for the reports.
So I tried to correct the relationships and now one of the reports works fine. I no longer get the error, but the data wont populate for the "provider" report. I tried to see how I can change that relationship and cant see what I am missing. I am looking at the query as maybe that is where the error id now. (Leave it to me to fix one error and cause another).
Your provider IDs in the two tables contain no matches. Look at the IDs. They are not the same.
That was something I should have noticed right away. I reentered the Provider numbers to match. I keep going back to your post about the relationships. I have deleted and reentered them several times and clearly I am missing something. You indicated I was linking Patients First Name with the Provider, the Nurse First Name with the date admitted. I cant see that (and it wasn't my intent. I tried to create a relationship between providers and patient records, patients and patient records and nurses and patient records. The nurse connection works fine but the provider connection does not tho I keep trying to do it the same way. I am so sorry I am likely missing the obvious?
Last edited by Juli; 04-21-2019 at 03:37 PM.
I have been working on the relationships and now have the second query to work. So two out of three... The patient provider query wont populate. I don't know if the error remains in the relationship or if I am designing the query incorrectly.
In that query, you have the Medical Records ID in the patients table linked to Nurse ID in the Nurses table. I think that you need to link the Medical Records ID in the Patients Table to the Patients Record Table.
Glad that you solved this and thanks for the REP.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks