Search results for query: *

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

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.

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

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

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

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

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

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

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

Thanks, I figured it out. I had to import each FMP table separtely into 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

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

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

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

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

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

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

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?