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

    Excel Form with Traffic Light Result

    All, thanks so much for your assistance. I finally got the formula to work! Have a great day :)
  2. CBlackmo

    Excel Form with Traffic Light Result

    GlennUK, thanks for the formula. It worked but only the first 3 drop-down list selections. When you select the 4th list option, the formula goes to N/A.
  3. CBlackmo

    Excel Form with Traffic Light Result

    Each question's point value is added together for a grand total. The grand total is the red, yellow, green. My question is how can I take the answer from the list box selection and assign the point value? Age List box: Totals for each question 30-36 Total point...
  4. CBlackmo

    Excel Form with Traffic Light Result

    I'm not sure conditional formatting will help. The table listed below is in a drop down box so the user selects one of the age groups. Each selection returns a value (the # listed beside the age). Thanks for your help. age 30-36 3 37-43 2 44-51 1 52-63 0 64-68 1 69-72 2 73-78 3 79-81 4...
  5. CBlackmo

    Excel Form with Traffic Light Result

    I have 7 questions with a list of selection results for each question (1 answer per question)that correspond to a number of "points". I want the user to select the answer from a list and then have the answer populate a field with the point associated with the answer. (example: Question 1 is...
  6. CBlackmo

    MS Access - Count Number of Cases

    Thanks for your help (Everyone), I think I've got it from here on.
  7. CBlackmo

    MS Access - Count Number of Cases

    I include the second table (either procedure or equipment)because we either need to look at a specific procedure or a specific piece of equipment that could both be listed more than one time per case number. When I run the query it shows me the case number every time the specific item from the...
  8. CBlackmo

    MS Access - Count Number of Cases

    SQL Statement: SELECT Cath.Date_of_Cath, Cath.CaseNumber, Procedures.Procedure_Name FROM Cath INNER JOIN Procedures ON Cath.Cath_ID = Procedures.Cath_ID The result I want is to have one case number no matter how many procedures were done. I'm not looking for a specific procedure, just a count...
  9. CBlackmo

    MS Access - Count Number of Cases

    I have two tables: Case Information and Procedure Type. The Case Information table contains the Case # and the Procedure table contains the different types of procedures. One case # can have multiple procedures. So, I want to count the case # only once even if it has 3 procedures associated...
  10. CBlackmo

    Export FMP Database to Access

    Thanks, I figured it out. I had to import each FMP table separtely into Access.
  11. CBlackmo

    Export FMP Database to Access

    Key field as in creation date? When I exported, I clicked on file export and exported as a .dbf. Any help is appreciated. thanks
  12. CBlackmo

    Export FMP Database to Access

    I am having a problem exporting a FMP database to MS Access. I selected the main table and all related tables. The related tables include multiple records for one person. I tried grouping and not grouping the fields too. I saved the file as a .dbf The result in Access shows the field names...
  13. CBlackmo

    Excel Calculation Problem

    I am writing a report that shows This Month Qty (A1), Same Month Last Year Qty (A2), and want to use it each month with the Year-To-Date (YTD) quantities changing for each month (running total) of YTD Qty (A4) and Last YTD Qty (A5). Unfortunately, I keep getting a circular reference. Is there...
  14. CBlackmo

    SQL Date Query

    It worked! Thanks for your help Terry. You are a life saver.
  15. CBlackmo

    SQL Date Query

    I tried the following example and it returned 0 rows. Any suggestions? SELECT Demographics.Last_Name, Demographics.First_Name, Event_Cath.Cath_Number, Demographics.Patient_ID, Event_Cath.Account_Number, Event_Cath.Date_of_Cath FROM Demographics INNER JOIN Event_Cath ON...
  16. CBlackmo

    SQL Date Query

    Hi All, I have just upsized to a SQL database and must re-write Access queries. I want to create separate queries to find out the list of patients seen yesterday, 2 days ago, 3 days ago, etc. One table includes the date field and the other table includes demographic data. I've tried getdate...
  17. CBlackmo

    Exclude dates from a range

    Thanks for your assistance; I used: Between #1/1/2000# and #7/31/2001# or >=#9/1/2001#
  18. CBlackmo

    Exclude dates from a range

    I have written a select query that looks at data from >=1/1/2000 to present. My problem is that I need to exclude one month (August, 2001) from the this date range. Any suggestions?

Part and Inventory Search

Back
Top