Recent content by Cassidy

I am working on a report and I am having issues changing the coloring of the rows in the report. If possible, I would like the first column to be completely white with no alternating color because there is only data in one cell at the top of each grouping. So the column with "Aggregates"...

I know I can hide it in a query, but can I hide it in a report? I have included a screenshot of my query. I want my report to include the sorting from the "Subtype" field without the "subtype" field being visible on the report. Can you hide fields as simply as with queries or is there someone...

Hello, I have a table of about 250 items that are sorted based on two fields. I created a query of the table and hid one of the fields because it is only there for sorting purposes to group the data. For example, I have a "Type" field. In the type field, I differentiate the items with...

Ok, so should I list all equipment in one table and distinguish between owned/rented with a yes/no check box? I think that would be the simplest way but I'm not sure if that is the best way. The company I work for isn't a huge company, so there isn't a large number of items, most jobs tend to...

Hello! I am building a database for an environmental remediation company. It will include a list of all the equipment and materials they own, all the equipment and materials they rent/buy, and a list of vendors. This is an ongoing project and this isn't my sole responsibility, so it will be...

Yes I felt stupid writing that I was experienced with Excel, I know the two look similar but are entirely different programs. It has been fun messing around with Access so far, I already took some online tutorial classes that is helping me remember how to do some basic tasks. Any suggestions on...

Hello everyone! I am working on building a database for an environmental remediation company to assist them in cost estimation and bidding. I have a great understanding of Excel, and I have experience with Access but I haven't used it in years so I am trying to re-learn the program so I can...