Recent content by chrisl

Hello, I have a query that runs great when I explicitly state a value in the criteria area in the query grid. However, when I try to run it through a dialog box using < [enter value] in the query grid and I get no results...even when I use the exact value I explicitly stated. The sql...

Good Day, I have a query that works great when I actually type a value into the criteria in design grid. However, I set up a dialog box for the user to enter the data in the design grid: <[enter value] When I run it with the dialog box, the query comes up empty, even when I use the exact...

Hello, I am working on a report that prints from a form. This form has a subform with many records that relate to it's parent. The only information that we are interested in on the report is the last record on the subform, aka the greatest numerical key from the subform that relates to the...

Hello. The query joins about 5 tables together with two conditions (one being provided by the user). One of the fields contains about 4 different values, let's say A, B, C, or D. What needs to happen is: A total of the records with an A or B or C (within the other two criteria). The...

Hi, I am trying to generate a report that uses the Dcount function. The report works great until I use a dialog box for the user to enter a value into the criteria. Any suggestions would be greatly appreciated. Happy Holidays.

Hello. I am trying to generate a report that identifies a row only once. However, I suspect that I am using the DISTINCTROW incorrectly. Any clues with this would be greatly appreciated. SELECT DISTINCTROW EdwaaDepartment.[EDWAAA(1,2,3,4,5,6,7)], MainDepartment.SID, Students.[Last Name]...

Pat, I really appreciate your reply. I will give your suggestion a try and let you know how it goes. Thank you, christine [This message has been edited by chrisl (edited 11-09-2001).]

Thank you for the feedback Charity. The field is a drop down menu with 4 different values to choose from. Is this bad design?

I am new with access and need a bit of help with a report. Is there a way to count 2 different values within a field and then divide it by the total number of records in the report (which is generated by another field) so that a percentage may be obtained? Any help is appreciated.