Search results

Dear all, Could you help me please? I have a column of data in the following format: ALBUMIN (35). I would like to have a query where a separate column would show only the numbers in Bracket. I would really appreciate your help & support on this. Thank you.

Dear Team, I would like to use the results from a query for more calculation. I have used count in design view, to count the number of times a word appears. I now want to do addition & percentage of the data. In the example given (attached) i want to add "I" with "OTCOL" for e.g. How can i do...

Dear Team, I have a table with 2 fields with dates - TestDate & ReceptionDate. I'd like to get the time difference between the TestDate & receptionDate - Basically, how long it took to do a test. Table attached. Thank you. Much appreciated.

Dear Team, I have used 'count', to count the number of times some records appeared in a column. Now, I want to do some calculations from the results I got from the query count. How do I do that please? Thank you. E.g I want to add INFUSED + DAMAGED (169884+3) EpisodeUnitStatus Count BATCH...

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