Search results for query: *

I have a report with a detail header, and multiple rows of data below the header. When viewed in Print Preview, the detail is shown correctly. When printed, the first row of data in the detail section is printed repeatedly instead of the correct data. What is going on? Can someone please help me?

I have a SQL statement that is dynamically built in VBA through an Access form. I have a calculation that is performed within the SQL statement that takes two fields from a table and divides them by each other. It is very possible that either one or both of the fields in the calculation could be...

That still doesn't give me what I need. It is filtering with the additional parameters within the Dcount function, but gives me the same number through all the rows. I need this for example (Field5 being the Dcount result, and parameters of Field1=a and Field2=b): Field1 Field2 Field3...

I have the following query run through VB: SELECT Field1, Field2, Field3, Dcount(Field1,tableName,Field5<7) As Field4 WHERE Field1=a, Field2=b GROUP BY Field1 The Dcount is working correctly, except that it is ignoring the WHERE and GROUP BY in the SQL statement. It is counting all of the...

nickske80, I tried that, but all it does is return that number of records in the grouping, like it is ignoring the criteria of <7. I hadn't tried your method before, but it gave me the same results that I was getting with Count(Field5<7), that is why I went to Dcount.

I have the following query run through VB: SELECT Field1, Field2, Field3, Dcount(Field1,tableName,Field5<7) As Field4 WHERE Field1=a, Field2=b GROUP BY Field1 The Dcount is working correctly, except that it is ignoring the WHERE and GROUP BY in the SQL statement. It is counting all of the...

I am trying to set up an Excel template for which I have a fixed number of columns, but no idea how many rows there will be. I am looking for a way to automatically insert formulas into a row once information has been entered into that row. Please help me, and thank you in advance.

They are bound.

I have form within a database that brings up info about individual business units with their corresponding image, each unit on its own page. When I view the form in form view, the images match up perfectly with their related information, but when I view the form in print preview or actually...