Search results

While puzzling about with calculations, I learned that you can create a calculation in a text box more or less the same way as you could in Excel. But this is limited to basic numeric calculations, ie [=5+5]. I'm still working on trying to use other cells (such as RegularRetail and...

I am attempting to create a pivot table that will cover information across four tables, so that the information can all be sorted and moved about at will. Unfortunately, I have run into 2 problems. 1. It seems I can only put together tables that are directly related to each other. 2. It seems...

Is there any way to add calculation fields to a data display screen? I'd like to calculate the quarter from the month and the weeks extant between two dates, and then display this data with the relevant form/report/document.

What is a parameter query? Is it in the object-> query window? Sorry for the nub questions, this is my first time working with Access. If anyone would be so generous as to provide a simple guide to how to create the proper field (a parameter query?) I would be eternally grateful. I think...

Got it! I think this project is really starting to come together now. Thanks very much for the help.

I have been working on a form, but I don’t know how to produce the results that I want. What I envision is a pivot table with a lot of customer/product/promotion information, which is in turn sorted/filtered by dropdown fields for “Customer” and “Event.” Also, I would like to create...

This is my first time working with Access, and I'm finding it a little more difficult than I expected. I’m not sure what the best way is to organize these tables or even how many tables I want to make. I work for a company that sells goods to retailers, and this database is to keep track of...