Search results for query: *

I'm trying to automate a form that was built in Excel so that the information within the form is automatically organized into a table on another sheet. I've worked out most of the process but the issue I'm having is that a part of the form lists different codes for each of the broadcast zones...

Hello Everyone, I've been tasked with automating an Excel 2013 report that uses pivot tables. So far it's working except when I get to refreshing the pivot tables. Now what happens is whenever a new report needs to be run, the data in the old report is cleared out of the Data Tab (except for...

Hello Everyone, I have an Access DB that has linked tables to excel data that I'm trying to compare. When I setup the linked tables I made sure to name the excel files something relatively generic so that any new data that was generated could just overwrite the old data using the same file name...

Hello Everyone, I'm using Access 2013 and I have a query "qryTTOver24" that shows every order that took longer than 24 hours to complete. What I want to do is be able to is select a record in that query and add notes explaining why it took that long. I already have a table setup...

What I'm trying to do is create a single report that allows the user to view overall turnaround times for all work orders in our system but also gives them the ability to drill down to specific regions and teams to see how they stack up against each other. I'm figuring that the easiest way to...

I have a .txt file that I'm trying to import into access. The import works well and the data comes through just fine except that the only way that I can get the date/time stamp for each record to appear is if I import that field as a text field. The issue I run into with that is that we need...

I'm having an issue getting a query to populate records based on the date range selected in my form. I have a form that has 2 fields for dates (Start Date and End Date) so that when I run my reports I can specify the date range that I want to report off of. Both fields in the form are formatted...

I'm using Access 2007 and I have a form that I'm trying to put a date picker into but it's not working. I can either get the date picker to show up but whenever I select a date the field still appears blank or I can just type the date into the field but then the date picker never shows up. I...

I have a set of data that I need to attach a revision number to. The revision number is located in a log message that is included in the set of data but I'm having difficulty isolating the number so I can put it into the revision number field. Here's some examples of log messages: Jane Doe...

What I'm trying to accomplish is removing duplicate records from a query based on the date/time stamp of the record. Now for a little backstory, we have a table of data that is a log of every status change for an order and the date/time that the status change occured. We are trying to report...

So here's what I'm looking to accomplish, I basically need a table full of dates along with other bits of information but more so than that I need a way for the table to update itself automatically without a user having to manually input dates and that's where I thought VBA would be needed...

Here's what I'm looking to accomplish: I have a set of data that we receive from a 3rd party application. The way the data is sent to us is in a log format where each record of the table is a change that's been made to a contract. And what we need to do is add version numbers to each contract...

I have a report that lists the number of hours a resource is allocated for each project they are on. Currently the report shows a subtotal for the number of hours in a given month which updates itself everytime someone filters the data. What they now want is another subtotals field to add...

I have a report that pulls product data based on a heirarchy system (4 levels). One of the criteria for the report is to exclude any recrods that are missing any piece of the hierarchy. For example...Level 3 is null but levels 1, 2, & 4 are filled in or Levels 2 & 4 are filled in but Levels 1...

Hi All, I have a query that pulls assignment information for every PM that's attached to a project both past and present. As a result I get a table that looks like this: Pnum assignID empID PM Role dateAdded assignStart assignEnd...

I'm working in an Access 2007 db and I have a table that stores forecasted hours by project by week-ending date (Fridays). What i'm working on is a report that shows those forecasted hours by project by month. The problem that I'm having is that some weeks are split between 2 months and they...

Hi All, I have a report setup that's based off of a query and in this report I have a Variance field that gets calculated on the fly based off of a couple of other fields in the report. What I want to do is have the Variance field turn yellow if the value in that field is >15% of the value of...

Hi All, Here is what I have: An Access 2007 db that has a table with data that I want to display on a SharePoint dashboard as both a datasheet and a chart. Here is what I want: The SharePoint display (both chart and datasheet) to be updated with the most current data automatically, either...

Hi all, Before I get started here's a little background on the setup that I'm working with. I have an Access 2007 db that collects data from multiple sources, compiles that data into various reports, and output's those reports to a sharepoint site via a macro. The issue that I'm having is that...

Hi All, I have a table that stores three different types of data (PID Hours, Revised Hours, & Actual Hours) for each package that we have so that I can report on them. The problem is that I also need to calculate the variance between some of those types. Here is what the Table/Data looks like...