Search results

Take a look at the attached example. It groups the report by usr_origin and puts a count by type in the group footer. Is that what you're looking for? What is the DataType for the usr_elapsed time field? Is it Date/Time or Numeric?

The attachment has one table with sample data. The report displays the detail and then the concatenated string in both the PageFooter and the ReportFooter. I've commented the code so you can follow along with what I'm doing. Hope this helps.

So when you ran the report it didn't bring up the code page at all? Is your db anything you can post so I can look at it. I'm sure all we have is some small item keeping this from working. If you do post it, I'll need it in version 2000 or 97.

That's a good tip! Thanks Bob

Haven't tried what you're asking but I get the username this way. Add to references:Microsoft Scripting Runtime Dim objNetwork Set objNetwork = CreateObject("wscript.network") strUser = objNetwork.UserName You could build your path using the strUser variable. Does that make sense?

Are you saying you want some info from each table to show in each record in the report, like Sales dollars for the day from one table and count of employees who worked that day from another or are you looking to do sub-reports where you'll have 4 different reports within a main report?

Are t-shirts the only item you have or do you have others like hats that will be in the same report but need their own grand total? If the report is just for t-shirts then add a textbox to the report footer and set the control source to =Sum(field showing color qty). For example, if the...

You can place code in the reports Detail_Format event to capture the data and assign it to a variable. You can then display the variable in the Page Footer or Report Footer by placing code in those events to assign the variable to a field in that section of the report. Is that what you have in mind?

You added the fields to display the totals in the page footer, correct? I'm sure you did, otherwise you should have gotten an error. I'm a little stumped if you didn't get an error. Let's try this. In the following section of code in your report, click the margin to the left of the first line-in...

Good, glad you figured it out.:)

Take a look at the attchment and let me know if that is correct. I can do this but it will take some code behind the scenes to make it happen. I don't know any other way to leave out blank columns. What is the table's name and are the fields Q5A Q5B...or q5a q5b or ? Also, what version of Access...

Take a look at the attached db. I believe the query is what you are looking for.

Did you use the ampersand instead of the plus sign in your formula? That would concatenate the field values as strings instead of adding them up to get a sum. 0 & 1850 & 0 would be 018500 0 + 1850 + 0 would be 1850

Did you just copy the code or did you adjust it to fit your field names? If you just copied it I'm sure it didn't work. Did you get any errors when you previewed the report?

I'm thinking I still don't know exactly what you're looking for but here's a db that has my first shot at it. It has a table with data, a query against that table and a report using that query. Take a look and let me know where we need to go from here. I'm sure I can give you just what you want...

How about this: UPDATE Orders INNER JOIN Dups ON Orders.IDOrder = Dups.IDOrder SET Orders.DeleteFlag = "Y"; This finds the rcds in the Orders table which have a match in the Dups table and sets the DeleteFlag to Y.

Great, glad I could help!:) A little code can make a big difference in the way reports work.

I'm assuming you're using vb code in the reports to do what you're doing now. If you set [Page] to 1 when the GroupHeader_Format event occurs, and the page break to visible=yes on the GroupFooter_Format event, when mod = 2, does that get you want you want?

Vacation! Now that sounds nice. I've got a week scheduled later in July. Send me a PM when you're ready to move ahead with this and we'll get it taken care of. Have a good time:)

Can you post an example of your table with some dummy data? I think what you want is fairly straightforward once I'm sure what the data actually is like.