Recent content by fortwrestler

Perfect...I never thought about using a linked table that way. Thanks for the help and quick reply.

Thanks Plog, I was successful in setting what you described up. I was thinking this was impossible and you made it simple. CJ, Since I have the HU Index set to No Duplicates, would just appending the tmpBlocked table to the "master" table suffice to add the new records? Also... What would be...

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...

I did something similar to that. I have multiple days, but by updating it on the query, it works. Thanks for the reply :)

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...

Yes, that would be the more appropriate term.

I did...Kinda working on it while checking these forums... So, I converted the format of the dates to "ddd" (Mon,Tues,etc), and matched up the column headings to this. This translates to the report nicely. I have another field with "Between [start] and [stop]" and this seems to be working...

Yours, Gina.... I understand the parameter part of the crosstab query, I'm having an issue getting it to display on a report. When I go to generate the report, the dates/fields are fixed rather than updated according to the parameterized crosstab query. Is this where I want to use Column...

Would I have to create a report through VBA for this to work? I think I'm understanding what you are suggesting, I'm just not seeing how to generate a report that's not predefined.

I added the Parameter to my query, however when I go to make the report, I can only get it to pull from the date range given. Is there a way on the report to make it day(1), day(2), etc? so that it auto pulls from the dynamic crosstab

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...

Got it...So i'm all caught up and good to go it appears. Now back to the original question... I can get the cross tab to display like I want, and generate a report from there....but I would have to create a report every time the week would change. Is there a way to generate a cross tab report...

Gotcha, So I've accomplished part 1. I'm kinda confused on part two.... So right now, my Reason is "Peroxide Issue_Filler" . Are you saying I should have Reason - "Peroxide Issue" , Equipment - "Filler" ? Then on my table say IF equipment = "Filler", etc then Upstream and IF equipment =...

Would the table that I make this field (PartOfDay - Days, Nights) be created within the stop tracker table, or would it belong in a table by itself? Or do you mean that within stop tracker you would have Line l Date l Reason l Day/Night l #ofStops I am sorting by the end part of reason name...

First, I want to say sorry about all this confusion...maybe I started off with too complex a project..... Anyways 1) The difference between Stop Tracker Table and Production Summary Table The Stop Tracker table is a detailed database of any given stop on any line. The main input on this...