Search results

I have a query that pulls up infomation from a table. The criteria is [Enter Program Number] I need to make a Like "." for [Enter Program Number] In a form which updates the table a user can enter in 1094 Argon Inter Express. I need it to be able to enter in just the 1094 or Argon, or Inter...

Awsome!!!!!!! Thanks alot...

Hi I have a form in which case I am trying to do a unbound equation. Here it is. (#of parts * quantity of parts)+(time * #of parts * 20) The #of Parts is just a text box (text49) that a user would enter in 3 for example in this case. The quanity of parts is a combo box that a user selects...

Also looking at the codeing I see WHERE ((([Employee Monitoring].Program)=1094) AND (([Employee Monitoring].[Client Number])=1000 Or ([Employee Monitoring].[Client Number])=6000) AND (([Employee Monitoring].Date)>[Start Date (mm/dd/yyyy)] And ([Employee Monitoring].Date)<[End Date...

Humm, dosent seem to work right. Says Expression is typeed incorrectly, or it is too complex to be evaluted. For example, a numeric expression may contain too many complicated elements. I will play around with the codeing though see if I can get something to work. Thanks for you help though.

Hil, I have a report that runs from a query here is the Codeing. SELECT [Employee Monitoring].EmployeeID, [Employee Monitoring].Program, [Employee Monitoring].[Client Number], [Employee Monitoring].Date...

Can I send you the database neileg and kevin? Maybe then you will see how it is built and to not have it normilized. Although I would say I am no expect at Access just a novice user. Thanks so much.:p

Well, I understand what you are saying but this database needs to have the fuctionality to change the data really quick. Each EVAL is different from the last Eval. The Evals can have 0,1,2,3,4,and 5 only. They are fields. Actually the Points is a Average field that dose not use the AVG()...

Hi there, hope anyone can help. I have a Form with Sum Total adding 20 fields together but I need to update the table. How would I go about haveing a unbound control updateing a table when the data is begin pulled from a query. (Query is the same as the table) Thanks alot. George

20 fields of points. Meaning 20 different controls Eval1-Eval20. I total up that and average all 20 together to come out with a TOTAL. The Total is where I am haveing problems. Here is the code. =(Sum([eval1])+nz([eval2])+nz([eval3])+nz([eval4]) +nz([eval5])+nz([eval6])+nz([eval7])+nz([eval8])+n...

sorry

20 fields of points. Meaning 20 different controls Eval1-Eval20. I total up that and average all 20 together to come out with a TOTAL. The Total is where I am haveing problems. Here is the...

Unbound Control Updates Table???? Hi there, hope anyone can help. I have a Form with Sum Total adding 20 fields together but I need to update the table. How would I go about haveing a unbound control updateing a table when the data is begin pulled from a query. (Query is the same as the...

For some reason I can not upload the database at 166kbs.

Thanks for the quickness Mile-O-Phile. I tried what you said...but what I am looking for is not working. Please help. I've included my database. End results, I am looking for a Avg() for the Average on the Employee Form, and on all the reports that does not calculate any 0's or null values...

Exclude Zero Values When You Calculate Averages Hello All, When you use the Avg() function in a report to average a set of values, the function uses records that contain zero values in the calculation. However I do want "0" 's to show up on reports if the Totals are "0". (I used the nz fuction)...

Zero Values ARGG Exclude Zero Values When You Calculate Averages Hello All, When you use the Avg() function in a report to average a set of values, the function uses records that contain zero values in the calculation. However I do want "0" 's to show up on reports if the Totals are "0". (I...

Hello All, When you use the Avg() function in a report to average a set of values, the function uses records that contain zero values in the calculation. However I do want "0" 's to show up on reports if the Totals are "0". (I used the nz fuction) For the report footer, the DAvg function does...