Search results

Thank you all. Worked like a charm. Exactly what I needed. Thank you.

Thank you Pat. I'll give it a try and get back to you. Thank you so much. I really appreciate it.

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.

Could i also ask please, if instead of putting "from qrycountsByStatus where episodeUnitStatus = "WastedInWard")"i wanted to put Infused + wasted In Ward, what would be the formula?

Hello jdraw. You are amazing. It worked. Thank you very much. Much appreciated.

Thank you both. Sorry Mark, my knowledge is poor. I could not work it out. I have now attached the original data. I want a query to count all units infused, wasted and presumed. After, I want to to a total number of all units then I want to do percentage e.g % wasted i.e wasted/total *100. Could...

The data is about blood transfusion status. IN = Infused , WIWARD=wasted in ward. The table I provided is the result from a query, where I counted how many units were infused and wasted, etc. I now want to used these number for calculation. e.g Infused + Wasted in ward= Total or Wasted /total X...

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

It worked. Thank you.

Thank you Ranman256. Date1 = [RequestDate]?

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.

I am very new to access. I have a created a database on blood stock. Then I have used "design a query", did a "count Query". That's where I got the results I showed you. I do not use form or report. Is it better to use form or report, because after I have pulled this data, I export it to Excel.

Dear The_Doc_Man, Thank you very much for your reply. My knowledge of access is very limited. I haven't created any VBA in Access. Do i need to go in "build>query> then put the above code ? 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...

Galaxiom, I am sorry, I do not understand this part : the datetime on the second instance as up to 24 hours later than the first. Take care with that datetime condition. Avoid DateDiff so the engine is not having to process all records in the second instance before selecting those to be joined...

Thank you Galaxiom. I am also trying your suggestion. My knowledge of access is very very basic, but I want to learn. So I will definitely give it a go now. Much appreciated. You guys are amazing.

Dear Ridders, you are genius. I followed your example and it worked. I can't believe I got the results so quickly,- results that would have taken me months to work out. Thank you very much.

1. Query to show with >4 units or >=4. Which? >=4 (starting with 4 units and more than 4) 2. Can those units come from more than 1 lab? just 1 lab 3. Does it count if different blood products are given? - In the column of products, I have RedCell, platelets, Plasma & Cryo. I am more interested...

Sorry, i should have mentioned, yes indeed, the time is also included with the date. LabNumber DateRequired patientID BloodProduct BloodProductId 1234 21/05/2017 10:50 MR X RedCell 111111 1234 21/05/2017 11:00 MR X RedCell 111112 1234...

That's correct. Thank you, Ridders. Much appreciated.