Search results

Thank you all for your input. I've found a way to work around this issue. PNGBill, you're suggestion to use multiple queries worked :) Thank you!

PNGBill - I will actually go ahead and do that. I appreciate your time! Thank you so much!

Hi Bob; Not sure if you got my follow up. You are taking my example too literally. I actually have 3 tables storing this information. One table contains the Customer information name, address, etc., another contains the purchase information, another contains the details per item. It is...

Boblarson - a P.S. The sample above is just a sample of field names to make the example I'm trying to provide easy to understand. I don't want you to think I have a bad design ;)

PNG Bill - Yes my database is a simple name and address storing database so there is only one table. I will try your suggestion of more than one query. And to Boblarson - thank you but my data is already normalized. In each record there is only ONE city. What I'm trying to accomplish is to...

Using: Microsoft Access 2007 Setup: I have an Access 2007 database with a single table containing the following fields: Name Street City State ZIP Purchase Price Purchase Date (From and To) Item Amount Ship Date (From and To) Item Cost Purchase Code Store Code State Code I have created a...

I created a report for a Crosstab Query based on the instructions provided by Microsoft knowledge base. I have no problem running this report in Access 2007 but when I try to run it in Access 2003 I get this error: "The expression On Open you entered as the event property setting producted the...

Thank you James. I will give that a try I'm just not sure how it will work out with the crosstab I have created.

I have a database that tracks sales calls. Each time a sales person leaves a voicemail, receives a call back, speaks to a customer or sets up an appointment a record is created. (i've attached a document with sample data) My dilemma lies in that I need to report by week and I need to be able...

The code is via a macro attached to the On Click Event of a button in the Form. The form has the 4 checkboxes for the reports I've attached a document with the Macro Definition. The reports open fine, it's just when they haven't selected at least one of the checkboxes it won't display the...

Sorry for the vague initial description :o but yes, I only need the message box to pop up if they forget to check at least one of the checkboxes. What happens is the users enter criteria and then forget to check a box for one of the 4 reports and sit there clicking the Run Reports button over...

Thank you for replying. I can test with ors however the user may choose to run just one report so or would return the error message if they choose to run just one report :(

Hello! I have a form that allows users to check boxes to select the Reports they would like to run. The checkboxes are named as follows: chkReport1 chkReport2 chkReport3 chkReport4 I wrote a Macro that works perfectly to run the reports if the check box is selected. (there is a run button...