Search results

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

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

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.