devagupt
Last Activity: Jan 16 '08, 12:40 PM
Joined: Oct 26 '06
Location:
-
how would i put in a 2008 condition? Please help! -
Small Query Question- Datepart function
Hello ,
I have a query which adds all the downtime for a given week and displays it. All i have to do is , is to type the week number and it shows be the data. However we have rolled into the new yr ( 2008). I would like it to display information for 2nd week in Jan 2008 for me. When i enter 2( 2nd week), it displays the 2nd week in 2007.
Please help.
Thanks in advance
Present CODE***... -
Report question
I have a table with many fields ( 10 fields out of which 6 are for specific product issues). Each of those 6 has a number enter in it via a form.I've created a report and dont need to display these 6 fields. Instead i would like to display the maximum number entered in the fields in a group of records ( as i would sum records based on the persons name and date). I need to display only
eg..
Name vial , stopper... -
Show new Record at top of Datasheet form
As of now the supervisors enter information into the packaging form . WHen they do , they have to scroll all the way to the end and start entering the information. The field names are on top and the information they enter is all the way at the bottom. They were wondering if they could enter the information from the top instead and at the same time have the remaining information displayed below so they would know what has been entered and what needs... -
pivot chart question
i have a form called get downtime data. WHen information is entered into it and the button "get downtime data" pressed , it displays the results of a query. WHen i view the query in pivot chart view , it only charts values which are over 1.Also , it displays only whole numbers and not decimal values like 2.3 etc.. I played with the scale tab in chart options and didnt get anywhere. I would like to display all values ( regardless of how... -
When i run the query , it displays it in Ascending and descending but it doesnt show the same in the chart/Graph. I wanted to know how it would show it in the graph. The query itself runs well. its the graph which isnt displaying the information as per the query .Leave a comment:
-
query and MS Graph/Charts help!
I have another question in queries and charts. I ran a query to count the number of records present in a field and sorted it in ascending order. WHen i make the chart , it doesnt display it in ascending order , i wonder why.Below is the code. I was trying to make a pareto chart which would display our downtime type from the highest to the lowest but for some reason it displays as is.Help please!
SELECT tblDowntimeTabl e.Shift, tblDowntimeTabl e.Type01,... -
If statement in reports
I have summed all "Actual production" in a report. I need to sum all " Packaged production " in a report. I have a check box "Inspect only " . "Packaged Production" is all the "Actual Production" minus the Actual production which have "Inspect Only" checked. How do i do this in a report? an IF statement?
Kindly help. -
populating a form automatically with a button
I have 2 tables , Production table and the Total table. The production table is made from a form and the total table just has data in it. I need to populate 2 fields from the total table into the production table. They both have a common field being the Vial #. Sometimes there are 2 identical vial # for a product but they are packed on a different line. I need the line speeds the lines would run at and the # of people per line which is all stored... -
I have 6 fields. They are
Date, Line, Shift, Downtime in mins, DOwntime comments and Type of downtime.
I want to write a query which will show me The accumulated downtime in mins for all the shifts in a given line for a week. Can i do this?...Leave a comment:
-
is there a running sum in a query?
I need to sum all the Time in mins in a given line. So i need to group by line and then sum all time in mins in a line so when i run the query it shows the line i typed in a query and the sum of all time in mins of that particular line which is stored in different recorsd. i hope i was clearLeave a comment:
-
SImple Query question
I have a question .
I have a Chart which i run from a query. The chart has 3 fields
Line , Date , Time in mins. The purpose of the chart is to display the sum of all the "time in mins" in a given "line" for a week( from date to date).
In the query i am trying to sum all the "time in mins" for a given line and display it as a sum. How should i do that?The query should also have the date, sum...
No activity results to display
Leave a comment: