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

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

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