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!

  • Congratulations TouchToneTommy 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: *

  • Users: CrakD
  • Order by date
  1. CrakD

    Grouping, sorting and counting correctly.

    It's not actually named any of those fields..i'm just using that as an example...It's actually a referral system..I didn't want to reveal to much...but...here's how it works...I need to be able to track referrals that nurses give the clinic. People call..they give basic information about the...
  2. CrakD

    Grouping, sorting and counting correctly.

    I have a db, in which there are several employees and on any given day they get an item abbreviation. Like this Date | Employee Name | Count| 06/1 | George | BEV | 06/2 | Chris | ICE | 06/3 | George | BEV | 06/4 | George | ICE | What I want is to be able...
  3. CrakD

    Getting multiple data into one line for reports

    I have a query that has employees and it has multiple items that are associated with it.... There is an employee information table. for example: Equip_rent_ID Employee_Id(query) Liable Equipment 123456 Gutierrez, Chris Nextel Radio 123457 Gutierrez, Chris...
  4. CrakD

    Need a transitiong tool

    I have 2 Databases. A Referral Database, an Active Patient Database. How it works is..the patients are referred by doctors, therapists, etc. The information like date of birth, address, phone number etc. is input into the database. Then when the patient gets evaluated (up to SEVERAL weeks...
  5. CrakD

    Many to many query but needs to be one to many query

    Well..here's the thing...it is a many to many. I do have it set up correctly. The problem comes into play when I want to run reports, using excel, since it's preferred by the boss. and I get this kind of thing Patient name Therapist Blow, joe Joe, nobody jane, mary palms, harry...
  6. CrakD

    Many to many query but needs to be one to many query

    as it is right now....i run the census query and it gives me this: Field 1 Field 2 PATIENT THERAPIST Blow, Joe Smith, Angel Blow, Joe Holmes, Sherlock I really need it to be like this: Field 1 Field 2 Field 3 PATIENT THERAPIST...
  7. CrakD

    Duplicate Data being produced in an append query

    I guess I had a brain fart. Thanks, I was making it much more difficult than it had to be. I appreciate your help. It's running smoothly thanks. Chris
  8. CrakD

    Duplicate Data being produced in an append query

    I have added a "referral_ID" I can't believe I made that mistake. K, let me see if this can be explained better. nurse calls -> receptionist enters info in intranet page -> data is submitted to "referral.mdb". Then the day the patient is scheduled to come in and patient...
  9. CrakD

    Duplicate Data being produced in an append query

    Hi, I'm co-oping in a pediatric rehab center. I am workin on an intranet page/database system. At this time I have 2 Db's, one ("referral_database")which get's it's info from a frontpage 2002 created db. The other db ("patient_db") which contains similar fields, like...

Part and Inventory Search

Back
Top