Search results

That was perfect! Thanks so much for you help!

Hi, I am trying to compute a variable "weight gained since last visit". So, I have the weight at each visit and I'd like the query to compute the difference since the last visit. The fields in the table are: Patient Visit date Weight Thanks very much for any help! -j

THANKS!!!! That worked great! I really appreciate your help!

i think i put everything in right - i've attached it if you want to check it, but i think it's all right. Thanks!

oh yeah - the last visit date and 2nd to last for each patient. also, one more thing, the ptidgrv is the id i need to group on - it's a variable that combines the ptid and grv as that is what is unique for each patient. Thanks!

db attached if that helps i've attached a db that has the table and the query - maybe that will help? So, just to clarify, what i need to figure out is the difference between the last visit date and the 2nd to last visit date. Thanks very much for your help!

now it's running, but in the prevvisit column it just says "#error". the date field is really a date too. Thanks!

ok, tried that but it keeps saying "invalid date value" and it doesn't like the "as PrevVisit" either - says invalid syntax. Thanks!

again- i'm not super smart with this stuff - how exactly do i do get the previous date in a query and use dmax to subtract? Thanks!

i'm sorry - i'm not super smart with this, but i'm not sure i understand. i can sort the records fine by the visitdate, but i need a column that would actually number them so that i can eventually subtract the max visit number to the max-1 visit number. So, my query might look like this: ptid...

Hi, i have a query which contains two fields: PtId and visitdate. I'd like to create a field that sequentially numbers the visits. If you're really smart, the second part of my problem involves computing the time from the last (or max) visit to the visit before it. I was thinking if I had the...

That's close Thanks so much for your help... It's close to what I need, but i need it to do that for each patient (identified by both patient id and grv) for the 2 month blocks... Also, is there a way to have all the other fields in the query or does that mess it up because, for the most part...

I am trying to create a sum of a field called ec2mo where mopp is between 0 and 2 and then another sum when mopp is between 2 and 4, etc... I've tried a number of different things, but it doesn't seem to work - instead i get a single value for each field (i'm assuming because there are different...

not quite... That would work except that I have to extract individual records from about 25 different tables and put them into the same 25 different tables in the other "archive" database. Thanks, j

Hi, I have a database of patients in a prenatal care clinic. What i would like to be able to do is keep "active" patients in one database, and when they are done (have their baby) they move to a permanent database. The reason is, that my database is on a network being access from two different...

Also, I tried the decompile, but it opened access and said - database is corrupt, make a backup and repair! ARGHHHH!!!!

I don't seem to get that far even...It's not creating the db files and I tried the jet repair too and that does the same. Thanks anyway!

thanks, i tried importing the data into a new database, but when I click import, it says that the original database is corrupt. I'll check into trying the other if I don't find something else.

Hi, I have a database that became corrupt when a user shutdown unexpectedly. Now when i try to open the database, Access says it must repair, which seems like it works, but then when it finishes, it doesn't open the database. When I close access and then try to open the "repaired" database...

that worked great! thanks very much!