Search results for query: *

I have data that needs to be summarized for different time intervals after a particular date . I Created a query that calculates months post the particular date and includes all the data that needs to be summarized. I have a table for the particular time period names : 6 Weeks, 6 months, 1...

Rick- So what if I change it to have a record source. BUt I still use those agregate functions. Will it work or does the criteria in those functions override the filter? Cathie

I have created reports that calculate various counts, averages and standard deviations of data. These reports do not have a specific record source. I need to filter this data based on criteria that is not directly related to the calculated fields. Is there a way to do this in general for the...

James- I am aware that by putting the diagnoisis in that table only one diagnosis can be entered. THis is what I wanted to do. This data is about followup after surgery and rehabilitation. The patients have only one diagnosis. It is not like your family doctor's office where each visit brings...

Jeff- Thanks for the vote of confidence. It still won't let me add another entry with the same patientid. I made sure the primary keys were correct. It says there is not a related record in the table with the basic information about the patient. In the relationship information, it says the...

THanks for the info. Just one more question. THe problem, then lies with the relationship I formed between the two table? It should be a 1-many? Is that: "All the records from the Table with Basic Patient Info and only those in the Office Visits that match" or "All the records in...

I have a dozen or so tables all linked by a primary key of a patientID and SiteID. I have a table that requires more than one entry for the same patient. It won't let me add more data for that one patient. I am supposing this is becuase the primary key involves the patientID and cannot be...

I have a table of information about certain patients for various exams. I have a field that calculates Months postOperation. So There are various entries for different times post op for different patients ex. Automatic Record# patient months post op Other Data 1 1...