Search results

Hello, I'm working on a database that imports data from an Excel file generated by SAP. The excel file shows all of the inventory(HU) that are blocked for certain reasons. Once the HU is removed from the blocked status in SAP, it is no longer generated onto the Excel file. Is there a way in...

Hello, I was wondering if there is a way to change certain details in a report to a percentage format based upon the value in another field. I have a report that generates from a crosstab that displays daily stops. However, on this same cross tab, i have an efficiency value. I would like to...

Hello, I currently have a cross tab query that I would like to create a report with dynamic date ranges. Right now, if I generate the report from the crosstab query, it becomes a fixed report for a certain date range which can't be changed without regenerating the report. Here is my SQL for...

Right now I have 7 Lines(Fillers). I have these stored in a table under a single field (primary key). Now, for each Line, there are multiple reasons which can cause the line to stop. These reasons can be duplicated among multiple lines, or they can be unique to a given line. Right now, I...

Table A - Three Fields 1 - ID Field(autonumber) 2 - Filler Name (duplicates) 3 - Reason (duplicates, somewhat) Table B - Six Fields 1 - ID(autonumber) 2 - Filler Name(dup) 3 - EntryDate(dup) 4 - Reason(dup, sometimes) 5 - Number of Stops on Days 6 - Number of Stops on Nights Query(Append)...

So, I'm trying to find the best way to do this, and I've been successful to an extent. I'm trying to create a report which has a certain piece of equipment, lists a few fields for each, which are then populated according to the date. Right now, i can get this format Line 1 Date 1 x # y # z #...

Hello, First, I am newer to Access, and have been learning on the go/web tips/youtube. I am familiar with programming language basics, and am starting to understand VBA. I am working on a form which can populate multiple prepopulated text boxes. Basics I have a piece of equipment with...