Search results for query: *

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.

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

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

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

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

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