Recent content by MikeRei

dhookom, I messed around with the report, but I cannot get the labels on the left side using this method. SkipVought, I have a way to export to Excel currently, but my issue is modifying the column widths and cell colors. I do not have much experience modifying Excel through VBA.

My apologies, my friend... I meant that some months there will be only a couple of columns to include (unique JOB#s). Some months, I may have 20+ columns to include (unique JOB#s). I am querying on any record that has a [MAIL DATE] that starts with the month the user selects, so some months...

I like the idea of the multi-column report, but my issue is dealing with the column count change each time. I would like a canned report that can be ran by the user for each month, but some months there will be 2 entries, and some months there will be 20. How can I get around that with the...

OK, so after a little work on my end, I found a way to get what I needed for monthly selection, and I now have all of my data that I want included in the report stored into a single table. Here is where I am now: [TestTable] contains the following fields; JOB_NUMBER(combination of JOB_ID and...

Andrzejek, you are correct, the last row in my source data is for the month of August. I would need that row to be excluded if the user selected July of 2023 (month 7 and year 2023). One of the other issues I am having is selecting the correct recordset for a monthly output. I am currently...

The row count in my source data could go anywhere from one record to 50 records, so I need to make sure it can grow as needed from left-to-right.

dhookom, yes! That is the output that I need. I then want to format it on a report. How did you get to that outcome? I apologize if I was not being specific enough. I don't really post to these kind of boards often. I appreciate all of the help I can get!

Sorry everyone. Some representative data is below: I need to take a table similar to this- ID JOB_ID DROP_NUMBER RECORD_COUNT START_DATE1 END_DATE1 START_DATE2 END_DATE2 START_DATE3 END_DATE3 START_DATE4 END_DATE4 MAIL_VOLUME 1 12345 001 10000 7/1/2023 7/5/2023 7/6/2023 7/7/2023 7/8/2023...

Hello, I am writing, because I have an issue that I just cannot overcome, and this site seems like the place to go with MS Access/VBA questions. I have a table that has roughly 20 different date fields attached to records by their JOB_ID number. It is all in a single table, and I have no issue...