Recent content by Gigi0614

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

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

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.

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

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

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

That got it!! Thank you very much!!

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

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

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

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

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.

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

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?

Thank you Crowley!! I will practice this.