Search results

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

Well, The query is a query of a query...but I will post them and try to explain. Query 1 : TotalStopsPerDayArea SELECT qry_02_TotalStopsPerDayDownstream.Line, qry_02_TotalStopsPerDayDownstream.EntryDate, qry_02_TotalStopsPerDayDownstream.DownStops, qry_02_TotalStopsPerDayFiller.FilStops FROM...

I partially have B. Right now, the crosstab query is only pulling from part 1 of Table A. I'd like to have a query which combines the two(A and B) This may not even be possible.... The picture is an example of what I'm looking for in a cross tab query

A. Production Summary Table - The List of Issues Stops By Area Query - Filler Stops and Downstream Stops. These two would be the sampling data. B. Current Result = CrossTab Query Expected Result = Target CT Query Is that what you are asking for? I want to combine the two tables from...

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

Sorry, I didn't phrase it as a question.... How do I combine the Issues Summary to include the Filler Stops and Downstream Stops under the same Row Heading? Or should I do this in a report? Pictures Attached

So, I redid my tables to match the above and appropriate forms. I'm trying to recombine the data in the Crosstab now, but I'm having an issue pulling in Filler Stops/Downstream Stops. Theoretically, those two issues could fall under the same Field Name as the ones above (but they are...

You asked for the SQL of my Query....I wasn't sure if you wanted the query from picture 1 or picture 2 from the previous post....Here are both Picture 1 SELECT qry_02_TotalStopsPerDayDownstream.Line, qry_02_TotalStopsPerDayDownstream.EntryDate, qry_02_TotalStopsPerDayDownstream.DownStops...

For my pictures, would you like query 1 or query 2

Makes sense and seems easy to do. Should I have a table with all the issues under one column? Also, is the query for the stops valid ? Like I said I'm newer to access and it's all a learning process for me so thanks for all of your help so far

Sorry, I deleted all of it because i didn't like the way my tables were setup. A. See Picture 1 ( Table - Production Summary Table) See Picture 2 ( Query - TotalStopsPerDayByArea ) - this query is combined data from other items, just summed up by day and area B. So I want to summarize these...

Sorry for all the questions, I am newer to Access and am probably trying to create a database beyond my understanding.

I'm having an issue with what to include for the VALUE. Also, my x,y,z (ie, quality/safety/etc) are populating across rather than down. Is this because I should list x,y,z in a single table

So the sample data would be as follows Form 1 : Filler = EQ5A Date = 1/1/16 StopFillerSubreason1 - ENTERED StopFillerSubreason2 - ENTERED StopFillerSubreason3 - ENTERED StopBoxingSubreason1 - ENTERED StopBoxingSubreason2 - ENTERED StopBoxingSubreason3 - ENTERED Quality...

Initially, I have three tables. One table stores the name of each piece of equipment(constant, same as Filler) amount of stops(broken up into 30+ sub reasons- reasons are constant), and a third table that asks for safety/quality/defects/CLs/CILscompleted (these are in columns, linked to the...

The dates are across the top(by line, just poor formatting).... I'm working on getting the second request fulfilled

Here's the actual data i am looking for (everything is off center) Line EQ5A 1/1/2016 1/2/2016 1/3/2016 1/4/2016 1/5/2016 1/6/2016 /7/2016 # of safety issues 0 0 0 0 0 0 0 # of quality issues 14 0 1 0 0 0 0 # of filler stops 53 14 22 0 0 0 0 # of boxing...

With the crosstab in this case, how would I create the # as a value. This number is directly autopopulated from a table

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

I've played around with creating a cross tab query for this, but have been unsuccessful and I'm not sure if that query fits what I want to do. I've seen references to creating a string to store the data for each day as a whole, but I'm not sure if thats the correct way to go either. Is this...