Search results for query: *

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

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

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

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

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?