Recent content by theDBguy

Actually, "tags" make more sense in Access than just simply connecting products together. In that case, when you want to list all products with a certain tag, it would be easier to query the tables by simply providing the tags as a criteria.

Hi. Sorry, I was at work yesterday and didn't have access to the file we were using, so I couldn't tell you what I did. If you open the file and go to the PivotTable Analyze tab on the Ribbon, you can click on the Fields, Items, & Sets button and select Calculated Field. From the dropdown...

I was about to say the same thing (using phone, so a little slow typing). Since you said a product can relate to multiple other products, a junction table makes sense. But, it could also mean, as already mentioned, creating two separate records to describe a single relationship.

I used a Calculated Field to add the formula to get what you wanted. I tried to do it without adding the extra columns, but calculated fields work well with number columns rather than text ones. There's probably a way to do it without adding those extra columns, but I thought I would give you a...

Okay, not sure if this is the best answer, but I hope it helps...

Hi. Welcome to AWF! As you can see, we can do this in Access. I am not sure though how you will do it Excel using a pivot table to supply the criteria.

Hi. Thanks for clarifying. I'll take another look when I get back in front of a computer. Sent from phone...

One way to find out is to give it a try. :)

0 and 0.0 are the same values, which to the computer is simply 0. So, if you want to see 0.0 on display, you could try using the Format property of the control where you're displaying it.

Hi. Welcome to AWF!

Hi. Welcome to AWF!

Sorry, but the sample file you provided doesn't match the image you posted. There was only one date in it. In any case, to add the Weekly Total, you could try going to the Ribbon and select the Grand Total button and turn on the Total for the Rows only. For example:

Glad to hear you got it sorted out. Good luck with your project.

What was the actual error message? What was the code behind Pad()?

Can you also post a sample Excel file?