Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Gigi0614

    Lastname Lookup Field

    Hi! I've got a Patient_INFO table that has information about patients. The key is PatientID. I have a lastname, firstname, SSN, ect.... How can I design my table & forms so that the user can do a lookup on lastname? I'm not quite sure how to do that...but I think you have to build the table...
  2. Gigi0614

    Summing fields in subforms

    PHV, Would you be interested in helping me finish this project? It's clearly over my head, and I'm under a time crunch... I just have a few calculated control fields on a subform that are sums of child records. Should be easy to do. Also, I've got a report that I need help with getting it to...
  3. Gigi0614

    ORDER BY & GROUP BY not working

    Oh, OK... I guess aggregate functions are SUMs and things like that, huh?? I guess I do not need the GROUP BY then. This is for a report. I want to break by on each unique Surgeon, and have infor for each one sorted by Date of Surgery & Time of Surgery.
  4. Gigi0614

    Summing fields in subforms

    Hi PHV, I looked up the DSUM syntax and here is what it said to do: DSum («expr», «domain», «criteria») I'm not sure how to do this... My expr = addCharges.cost domain = addCharges And here is where I'm confused... My criteria is a pretty nasty join between 3 tables: SELECT addCharges.cost...
  5. Gigi0614

    ORDER BY & GROUP BY not working

    Here's my query: SELECT scheduledSurgery.anesthesia, scheduledSurgery.LOS, scheduledSurgery.suite, patientInfo.firstname, patientInfo.lastname, patientInfo.surgeon, patientInfo.coverdbyins, patientInfo.surgeon, scheduledSurgery.DOS, scheduledSurgery.TOS FROM patientInfo INNER JOIN...
  6. Gigi0614

    Summing fields in subforms

    Hi! I'm not sure if I can do this. I've got a main form, and I'd like to created a calculated field that sums some values in one of my subforms. Can that be done??
  7. Gigi0614

    Elapsed Time Calcuation with DateDiff

    That got it!! Thank you very much!!
  8. Gigi0614

    Elapsed Time Calcuation with DateDiff

    Actually... TimeIN & TimeOUT are defined as Medium Time, ElapsedTime is defined as Short Time
  9. Gigi0614

    Elapsed Time Calcuation with DateDiff

    I have a form with TimeIN (short time) TimeOUT (short time) Elapsed Time ---> calculated field that is giving me trouble!! I thought I could use the DateDiff function: DateDiff ('h', [TimeIN], [TimeOUT]) But it's not working... For example if somebody entered the following TimeIN: 1:15...
  10. Gigi0614

    Yes/No field

    Hi! I am trying to setup a Yes/No field as a control on a form. I have 2 tables patientInfo and scheduledSurgeries. On the patientInfo table, I have a YES/NO field called "coveredByInsurance". How can I create a lookup field on the scheduledSurgeries form that would take the patientID from...
  11. Gigi0614

    From Publisher to HTML

    Hi! I'm new to Publisher, and I've got the Office XP version. How is the easiest way to convert a catalog that was made with Publisher (a .pub file) to an HTML file? I would like all the text in the .pub file to be HTML text, and not a graphic. Is this hard to do??
  12. Gigi0614

    Just want to look at the SQL!!

    So "BOUND" fields are updated when the user hits enter on a form. And it gets updated to the Record Source table. "UNBOUND" means that it is not updating anything when the user hits enter?? Is that right? Thanks for your help.
  13. Gigi0614

    Just want to look at the SQL!!

    OK COOL!! I think I'm getting the hang of this...where reports and forms are getting their data from. So I can code the query, store it, then in the form recordsource, just point it to the query I wrote. That makes sense. One more question though, if you don't mind... I dont think I quite...
  14. Gigi0614

    Black Boxes around combo box fields

    Hi! I'm trying to do a report, and I added a combo box to pull in data from another table. Then when I ran the report and printed it, these combobox fields where in black boxes!! What's up with that?? Am I doing this right?
  15. Gigi0614

    Parameter Query & Reports

    Thank you Crowley!! I will practice this.
  16. Gigi0614

    Just want to look at the SQL!!

    I guess I'm just making this too complicated!! I found the data tab of my form, and the Record Source is "procedure" that is the name of my table that these form fields are coming out of. Then if I position my mouse over the individual fields on the form, and look at the data tag, I get the...
  17. Gigi0614

    Parameter Query & Reports

    OK, then so, I will read up on command buttons in my ACCESS book. Thanks!
  18. Gigi0614

    Parameter Query & Reports

    OK, how would you do this... I've got a report that needs to be run every day, and may need to occasionally be run for previous days, or even future days. The report pulls records based on date. Hmmmm...I'm not sure how to do this...
  19. Gigi0614

    Form/Subform...filtering??

    I see, I see!! That was the problem. Thank you!
  20. Gigi0614

    Parameter Query & Reports

    Can you hook a parameter query to a report? Ya know a popup box that you enter values in, and it does a lookup on those specific records, then spits out a report?? I think you can do this, but my Access books don't cover that...

Part and Inventory Search

Back
Top