User Profile
Collapse
-
Thanks. I will read the link. -
Calculate total time
how do you calculate total time hours? I have sub total hours for each day and I've been trying to total all the hours. I'm getting odd numbers.
Thanks.
John -
-
Calculation of Time Cards of two shifts
I created a form with “Time In1”, “Time Out1”, “Time In2”, “Time Out2”. I’m able to calculate the time correctly when it was during the day shifts from 7:00 AM (Time In1) 5:00 PM (Time Out1) = 10:00 but when the time goes over 12:00 AM it appears that it was totaled twice. Ex: 4:00 PM (Time In1), 12:00 AM (Time Out2)= 16:00
Here’s the calculation I used:
=NZ([Time Out1]-[Time In1])+NZ([Time Out2]-[Time In2])
... -
-
Thanks.
On the calculated formula on the form and on the Data Entry mode- How can you make it default to "0" instead of showing "Error"?
John...Leave a comment:
-
Update Query
How do I use Update Query on my form to zero out the calculated formulas instead of showing error. I have at least 9 fields. One table and these fields are unbound. I'm a newbie so I need like an detailed instructions.
Thank you all.
John -
THANK YOU VERY MUCH!!!! I'll try it.. Sorry for slow response- just got back from work!
JohnLeave a comment:
-
Here's the existing SQL Code:
Thanks again!
[PHP]SELECT [Material Inventory].[Part Number], [Material Inventory].[Alternate Part Number], [Material Inventory].Description, [Material Inventory].Rev, [Material Inventory].[Unit of Measure], [Material Inventory].Location, Sum([Material Inventory Tran].[Qty Received]) AS [SumOfQty Received], Sum([Material Inventory Tran].[Qty Issued]) AS [SumOfQty Issued], Sum([Material Inventory...Leave a comment:
-
Yes- The "Reorder Level" field is in the same recordset that the query is run from. I'm having a hard time since that the "Qty On Hand" is an expression otherwise I can do some thing like "Qty On Hand<= Reorder Level" and it just doesn't work.
I'll try the first suggestion. Thank you for the reply!...Leave a comment:
-
Query Question
I am working with the Inventory Dbase and I have a “Reorder Level” field which the quantity varies. I also have a query field Qty On Hand
[PHP]Qty On Hand: Sum([Material Inventory Tran]![Qty Received]-[Material Inventory Tran]![Qty Issued])[/PHP]
I’m trying to make a query to show all "Qty On Hand" that is less than the "Reorder Level". How do I make that Statement.
Thanks... -
When you complete the form it enters onto your table. I created a Query base on the Table. But for some reason when you add data into the form it updates the table but not the query.
I got it resolved I basically use the wizard and I was able to do the query right. Didn't know why it wasn't updating the query before.
Thanks for the reply though..sorry for the confusion.
John...Leave a comment:
-
Query not Updating
I have a query base on a table that is not updating. It fills up the table but not the query. Any ideas?
Thanks -
Thank You very much.....It works....:>)...Leave a comment:
-
Query Question Linking
Help Please….I have 2 tables (tblWorkOrder and tblItemMasterLi st). Under tblItemMasterLi st has a Child which is a BillOfMaterial linked by ItemMasterListI D. BillofMaterial( child) can have more than 1 item. What I would like to do is be able to open a query of tblWorkOrder and pull out the table from BillOfMaterial by Part Number from tblItemMasterLi st. Let me know if this descriptive enough otherwise I’ll explain further. Thanks again! -
-
Where do i put the Query SQL and the Function... Sorry I'm a newbie and still learning...
Thanks again.
J...Leave a comment:
-
-
Query Question
I am trying to create a query for my sampling size table and I can’t get the right expression i.e. Lot Size 1 to 50 = 5 and so on… I tried the AQL: IIf([Test].[Lot Size]<=50,"5") and I can’t pass the beyond this expression.
Lot Size ----- Sample Size
1-50 ---------------- 5
51-90 --------------- 7
91-150 ------------- 11
151-280 -----------... -
Combo Box orientation in Report
I'm trying to figure out if there's a way to orient (vertical) the Combo Box in Report? I know that the Text can be oriented in the property under the "Vertical" - and putting "Yes".
I found a way to do it- I changed the property to Text and I was able to change the orientation.
Also- after 6 consecutive times opening of the access program- it appears open with the opened icon but the program does not launch....
No activity results to display
Show More
Leave a comment: