Recent content by lark_tilly

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