Search results for query: *

If a form is looking at a query result, and you use the form to change the data (Which will change the query result), how do you refresh the query result without exiting the form and going back in. The form is datasheet view, and therefore I can't create a refresh button. Thank you for your help.

I am looking for the keyboard shortcut, not the formula. Thank you!

[findings_mammo]![date] is the appointment date I want to automatically fill [pending exams]![duedate] which should display the due date of the next appointment to be 12 months from the last appointment date. Thank you

Here is a code I am working on for the field on the form: SELECT Form!pathologyreport![result] WHERE IIF(Forms!pathologyreport!pathologyexamcodesqry subform.Form![type]="malignant",Form!pathologyreport![result]="malignant",Form!pathologyreport![result]="Benign") Am I anywhere close to the...

I really appreciate your help. I have created a field on the form and put the code in the record source of the form, but I am not getting a result. There is not a field 1,2,3,4,5. Each code is in a seperate record in a query looking at table 2 attached to the the recordid on the table 1...

I do not have anything. I don't know where to start. I have up to five records in a query, linked to the table, which show the different results per code chosen. I have a result field in the table which should represent malignant if any of the five codes were malignant and benign if all codes...

SELECT [pendingexams].[ptid], DateAdd("m",12,[findings_mammo]![date]) AS duedate, [pendingexams].[datescheduled], [pendingexams].[procedure], [pendingexams].[datecompleted] FROM pendingexams INNER JOIN findings_mammo ON [pendingexams].[ptid]=[findings_mammo].[ptid]; Thank you!

Actually, I have not worked on the report. I am just trying to get the field to display this information on my form. I will use this field for reports later, but right now I just need to find the right code to pull the information correctly. Thank you for your time.

Currently, I have dateadd("m",6,[appointments]![appointmentdate] The query shows a record for each appointment with the new date. I want one record to show with a due date based on 6 months from the last visit. How exactly would I implement the above information with what I already have...

Thank you in advance for your help. I want to create a dateadd field in a query to display when a patient's next appointment is due. I need to find the most recent appointment date and add 6 months to it. I know how to use dateadd, but how do you tell the system to use only the most recent...

Correct. The field will live in a query of course, but will be used to display on a form and on reports. The main issue is having one place that determines an ending result (One field) of malignant or benign based on the 5 chosen codes on the exam table. Thank you.

Thank you for you time. The field results are actually malignant or benign. You have 5 test that show a result. I have these is a query like you(Leslie) told me so that each choice is an individual record tied to the same reportid. ID Code Def Result 123 AB XXXX Benign 123...

Thank you in advance for your help. I have a query that displays positive or negative in a field based on a calculation. There are four fields that display positive or negative. They are all attached to the same record number. example: record Value 123 Positive 123 Negative 123...

Thank you for your help and patience. I have been working with this and i am still having problems. Table one is a master of diagnosis codes Table two is an exam with 20 fields per record. For one given exam (record) you can have up to 5 diagnosis codes to be chosen from table one. Can you...

Thank you in advance for your help. I have a table that consist of 200 codes and their definitions. In another table I need to choose up to 5 of these codes to define a given task. I want the definition to automatically appear when I choose the code. I know I need to build a query to pull...

Thank you for your time. I have a form that looks at a query, which of course looks at a table. In the table I have a field that is set to the text datatype with a default set to 2004/2005. It looks fine in the table, but in the query and form the default shows .999501495513. Same situation...

Thank you, deleting the page break took care of the problem. I appreciate your help.

Thanks for your help everyone. This one is driving me crazy. I think it does has something to do with the report footer. When I add a footer, it prints on the last page. I assume this is because I have a page break within my grouped information. But, I deleted the report footer and the last...

Thank you, I appreciate your help.

So, how do I trouble shoot this. I do not see any reason why the last page should be blank. On a 20 page report, 19 pages are perfect. But, page 20 is blank. Thank you.