Recent content by Geotch

I'm using Access 2010, Outlook 2010 with a gmail account. I'm trying to collect data via the create e-mail option and I get a message "Outlook could not be started. Make sure Outlook is installed and properly set up on your computer." I set up a Macro to email a query and that works. Any...

See if this helps. I guess he took the video down. http://www.accessandexcelhelp.com/msaccess/2014/8/12/access-version-of-a-pivot-table-the-crosstab-query-trick

I use Mike Alexander's trick for most of my crosstab needs now. It helps with issues like you are having. One thing that he leaves out is to do an "all other" just in case you miss something. Here's his video. http://www.datapigtechnologies.com/f.../crosstab.html

Here's a picture of what I do with the drop down box. Go to the query pane of the drop down: 1) create a 2nd column with all the data you want 2) after choosing the item on your form, display column 2 (which access calls column(1)) in a text box on your form. Hope that helps.

I looked at your database and you are close. You need to change the Product ID in the table: Invoice-Product to a lookup field. Here is Microsoft's Support page, but there are probably better instructions somewhere...

Take the word count out =(iif....

Did you try my example?

Look at this query, multiple steps but gets the month you need. I'm not sure using the 7*week will work out perfectly.

Data: CustID 1st 2nd 3rd 4th 5th 6th 7th Count 2233 7 3 0 0 2 8 0 4 Try this: (untested): Count: iif([1st]>0,1,0)+iif(2nd]>0,1,0)+..... This should give you a count of 5

I took the example back to an Access 2000 file so you should be able to open this one.

Which version of access are you using?

Have you worked with any vba? If not I can show you how with queries and macros. Edited - found my example database that uses a form to select an order #, populates another field with the email address associated with that order. No VBA, just macros, queries and forms.

You can use the Macro -> Email Database Object. How are you deciding which supplier's report to print?

Here is an example database. You must save the picture as the 24 bit bitmap. If you don't it will turn out like employees 2 and 3 in the attached database.

Sorry, read more into the post. I figured Steph wanted to see report summary calculations on each page of the report.