Search results

You say "have it output and save seperate pdf for each row of data" - you mean a report for each store, correct? If you're familiar with vb you could create a recordset of stores with entries for the month and then iterate through the recordset and call the report, changing the report criteria...

Before we try to dig into this any further I have a couple of questions. Are all of the excel files identical as far as the columns go? What I'm trying to figure out is what you're trying to accomplish by creating all these relationships. Is there like a file for each day or sales region or...

You would need to create a query that uses your combo boxes as criteria. Then set up your chart with the query as it's data source.

These are unbound checkboxes on a form and you want to check some of them and then show those values in a listbox? Is that correct?

I'm confused as to what you would be splitting if you're keeping the queries and form with the tables. Am I midundertanding?

I don't believe the 2nd sub knows the value of the strTable variable from the 1st sub. The value is local to the 1st sub. Try changing your code to Call NewRelation(strTable) and the name of the 2nd sub to NewRelation(strTable as String). That should pass the strTable value from the 1st sub to...

Take a look at the attached. I added a crosstab query which uses your query as it's data source. Actually I made a copy of your query and put in values because your form wasn't working right and your query didn't work as a result. I believe the crosstab will do what you're asking.

If your data is stored like the following, I don't see how you'll do this with simple queries-> office..question..answer If it was stored like-> office..question..N..Y..N where the Y would represent "No" then it wouldn't be a problem. I can see doing what you want with code by reading the data...

Here is an example if I understand what you are asking. Note that by hiding the groupfooter in rpt 1, there doesn't appear to be a break between customers. rpt2 just hides the total field so you have a break. This is done by the code in the report detail and grouping sections.

It doesn't look like you can with any simplicity. All the items returned by Google either say no or present some complex programming system to do so. Most of the hits refer to SQL server. Hope someone else has a suggestion.

Can you re-post the mdb in version 2000?

Try using the Top Values property In your qry, set the Top Values property to 1 and set the sort on the date field to descending. That way you should only get the most recent date record. Watch when you change the value to 1 from All. It tends to change to 100 so be sure it's correct before you...

Good! Glad I could help.

Noobie help with reporting Take a look at the attached. simple table with yes/no field qry to count the yes and no data report with counted qtys and two text boxes with the formula to calc pct

Do you need the message box? Can the user just enter the dates in text boxes on the form? If so, then the criteria for the date fields in your query can reference the text boxes on your form. For example: Forms!myform!txtbox1

I'm working on this. As usual, I ran into a couple of other things that needed to be coded that we didn't discuss. I'll explain when I post the completed report for you to look at. Might have it Wed, probably Thursday.:)

I don't see any way to do what you're asking using the queries you have. Unfortunately, it doesn't always work out like that. I put together a different approach in the attached db. It will double the nbr of queries, but in the end you will only have a single copy of each potential duplicate...

The best way to do this will be with some code in the Detail_Format event of the report. From there you can store the values needed until the logic says its time to do the calc. I'm not at a computer with Access at the moment. If no one helps you with this before I get back to one I'll write...

The attached has a combo box. Pick a job and the report will print. If you look at the code for the report, you'll see how it calculates the down time and how it keeps track of whether or not to calc a down time value. If you're not familiar with code, then open the report in design view, go to...

When the query is in design view, there should be what appears to be a capital "E" on the tool bar, looks like it might be in a Greek type of font. If you click that the query should than show the Total row. See the attached.