Search results

Thanks, i will try it that way. It should do the trick.

Hi, I have a pretty standard form to enter data about contracts. Depending on the type of contract, the user will answer a yes/no type question, and the result will determine what set of information needs to be entered next. Since the variables are grouped intrinsically, I would like to make...

I have a form to be faxed to various individuals based on the records in an access database. Previously, this has been done using the merge fxn in Word, importing the data from a query. I think this could be better set up as a report in Access, but do not want to spend the time redesigning the...

Thanks everyone for your comments and suggestions. The_Doc_Man, we are not looking to have page breaks between each patient because the diagnoses are not the primary sense of what the report is for, just incidental data. Hence the desire to compress for space. More a matter of 'while we...

In response to: I understand your problem, I think. We did this by writing a function that took the person, returned all the rows of date/diag. and concantonate them together. we usually call this in a query that returns the other data and it is easy to use that way. Downside, large reports can...

Thanks for your comments. To further explain the issue, we have to eventually print out the table or a report showing all the diagnoses per date per person. So whereas I understand your well taken point about normalization, I would like a way to be able to show this data without printing out...

I have a table with several hundred records. Up to 10 of these records belong to single individuals; with the only difference in the records being in the date_seen field and diagnosis. I would like to make this more efficient and store the data with one record containing several dates and the...

I don't have a website but I rave about this forum to everyone it could possibly be helpful to. I have learnt a great deal over the past year both from browsing and having questions answered and trully appreciate all of you. Hopefully word of mouth will help some.

I think I found a workable solution - (by reading some other posts, sorry about that! :o) I added 'distinct' after the word 'select' in the SQL view. It seems to have worked! Baquist

Hi, I have a table which has duplicate records. I can tell which are the duplicates by using the find duplicates query, but I need to be able to get a table with a unique occurence of each record. I can do this in SAS using the sorting procedure with the 'nodupkey'; how does one do this in...