Search results

Dear all, I have a database on blood transfusion. Every Blood sample of patient is allocated a unique lab number. Should they need blood transfusion, all units transfused during the validity of the sample (usually for 3 days), will be under the lab number. Some patients get transfusion other...

Dear Sonic8 and Markk. Thank you. These were exactly what I was looking for and they work. My Team was impressed when I showed them, but the credits go to both of you. Thank you so very much. On that note, similarly, I am on my way to help others in my own field. I am very grateful.

Hello Sonic8. Apology, my mistake. I have put all transfusion data from 2014-2017 in one table and the whole data comes up to 303mb! (not 2Gb). I have 2 tables. For transfusion I have named it tbl_all and solus for surgery. In tbl_all i have fields: episodedate, bloodprod, hospital number, price...

Many thanks for your smart suggestions. I will try this now. Wouldn't I run into the limitation of ACCESS, that is, restriction to 2GB per table? When i use UNION, I link data from tables 2014-2017 and I was planning to add more.

If this is external data imported into the db, consider changing the process to import this data into one single transfusion table containing all the data. Thank you, Sonic8. I import my monthly data from Excel To individual Access table then link them together with UNION. If it is not the...

Many thanks for your reply Sonic8. They are indeed typed as date. The transfusion table is a database I have put together using UNION. I have transfusion tables for 2015-2016 (monthly as well) linked in one by using UNION. The I have linked this 'database 15-16' in the surgery table. However, I...

I am very sorry. I am getting the error message - "Data type mismatch in criteria expression." I don't know where I am going wrong here. Thank you.

Dear Sonic8, many thanks for your quick reply. I really appreciate your help. I will give it a try now. Thank you.

Dear Team, I am new to access. could I have some help please? I have a table with a list of surgeries performed in a year and another with a list of blood transfusion received. As transfusion tend to happen after surgery, this means transfusion date will differ from surgery date. When I link the...