Search results

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

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

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

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

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

I have a computation in a query which results in numbers with extensive decimal places. I need to match the calculated values to a lookup table where the matching value only has two decimal places. Because of this difference, they don't match. I tried making a new table from the query and...

I need to convert grams in a query to pounds and ounces as two separte values. I am not a visual basic programmer, so does anyone know of a way to do this without programming? Thanks! -J

I have a form where the primary key is called ptid. When I have someone entering data, I would like the form to display the record for that person if they already exist, but if they don't to just be blank. In other words, the data entry person is entering ptid 123, if 123 is not already in the...