Search results

Exactly what I need! I have developed the database I need for my intranet or internet. We have both that would allow users to input the data. I need advice. I can use Frontpage or whatever. I just haven't seen a step by step to get it on the web or server. Is my thinking wrong that if I...

Can't wait to plug this in! Thanks for the help!

David, I am counting the patient days within a month. Not the patient's total stay, thus the variables. Actually, the Excel formula works fine. I'm lazy and would rather just have a query and not export my data etc. I am in awe of the problem's resolved on this site, so I just thought I throw...

I tried that, now it seems it won't accept more than one Iif. My current looks like this: IIf([Admit Date]>#04/01/2002# Or [DischargeDate]<#04/30/2002#,"0", Iif(( [Admit Date] >=#04/01/02#and[DischargeDate] <=#04/30/02#, [DischargeDate] - [Admit Date] ) ,Iif(( [Admit Date] >=#04/01/02#...

Thanks! No doubt that had to be done, but it highlights my very first "or" telling me I've entered a common with out a prededing identifier or value.

I want to count patient days within a month. I have solution reached on 04/19/02 on this bulleting board, this is less cumbersome. Excel Formula...

Thanks, Harry -- I think I am having a date format problem because that should work and it's not. I am using the excel solution given to Joey on his question. I would love to apply the code -- it's just over my head. I have a very functional DB but I have to use the expression builder and...

Thanks! I don't work for the NHS, just a little hospital in Louisiana! But it worked for my dilemma

Goal: Count of Patient days in a month Feb. by patient account Conditions: admit >02/01/02 and discharge >02/28/02, then 02/28/02-admit admit >02/01/02 and discharge <02/28/02, then discharge -admit admit< 02/01/02 and discharge >02/28/02, then 02/28/02-02/01/02 admit < 02/01/02 and...

I am in the same dilemma. I need a count of patient days by month. I've got total patient days set up also I have a report that I generate for a daily census. I need to be able to look at with patient by any day. If I have to I can purchase a program for that only. Any suggestions?