Thanks for the ideas. I didn't know you could make the report query you at run time for the parameters to include. Had I known that I probably would have included fewer reports.
I've been busy studying for an exam coming up early next week which is why I haven't been responding but I'm digesting the suggestions and I'll be back after the exam. Thanks again for the thoughts, they really have helped. On Feb 14, 2008 2:51 AM, John Toliver <[EMAIL PROTECTED]> wrote: > Hello all, > > I need some help. I'm new to creating databases. I have only > recently developed interest in them when I discovered how I can > structure my information into database format and use it to > computerize and simplify my paperwork flow. A little background, I'm > a nursing student. If you're familiar at all with the field, you're > aware that a fair amount of it has to do with paperwork. At the > least, creating a table like document with select points of interest > for medicine, lab values, diagnostic results pathophysiology etc. for > each patient under my care. I have figured out how to take the data I > gather, and convert it in to tables with the proper formatting to > display the data the way that I need to for submission. > > With that said I have a few questions about methods of manipulating data: > 1. When I create a report, I may spend an hour or more getting the > report so that it formats my data the way I want it to display. I > choose to have my report set to display the results of a query. If I > wish to create another report looking at different aspects of the data > I would do this through another query (ie scenario 1: query me all > apples in report format A. scenario 2: query me all oranges in report > format A) My problem is once I create the report that took an hour to > do. I don't want to recreate the entire report pointing it to the > second query for displaying in report format "A". I want to be able > to At any rate copy it and paste (duplicate the report template) and > then change the data source from what it is displaying to data B but > use the duplicated report template. from query 1(apples) to query 2 > oranges. Is this possible to do, or must I create each report > manually through the wizard and point it to the data source I want? > > > 2. Is it possible to undelete a table you have already deleted? :-) > > 3. Is it possible to import a table into base. For example if a > fellow student is keeping track of another body of data, and I wish to > import her work, how would I import her table data to my database? > > 4. When I am in the Forms section, I have found that the default > fields the wizard creates aren't that useful for the type of form I am > creating now. I need the flexibility of a text box. The problem is > the text box seems not to support a human readable label. So if one > field is for patient history, and another is for comments, I wouldn't > know it unless I remembered. How do I put visible labels on my text > box fields so that when I am working with the form I can see the title > of the fields? > > 5. Also, how do I create the fields that the default wizard creates. > I can insert text boxes and other objects in the form but I can't find > anywhere that handles the fields the form wizard creates. > > > Any insights you could provide would be much appreciated.... > Thanks in advance... > > John, > -- > Patience yields far greater results than brute force or rage ever > could so relax......it's just life !!! > -- Patience yields far greater results than brute force or rage ever could so relax......it's just life !!! --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
