User Profile

Collapse

Profile Sidebar

Collapse
John Torres
John Torres
Last Activity: Nov 3 '08, 11:07 PM
Joined: Jan 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • John Torres
    replied to Calculate total time
    Thanks. I will read the link.
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Calculate total time

    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
    See more | Go to post

  • John Torres
    replied to Calculation of Time Cards of two shifts
    Thank you. That works!!!
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Calculation of Time Cards of two shifts

    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])
    ...
    See more | Go to post

  • John Torres
    replied to Update Query
    THANK YOU. That works!...
    See more | Go to post

    Leave a comment:


  • John Torres
    replied to Update Query
    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...
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Update Query

    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
    See more | Go to post

  • John Torres
    replied to Query Question
    THANK YOU VERY MUCH!!!! I'll try it.. Sorry for slow response- just got back from work!
    John
    See more | Go to post

    Leave a comment:


  • John Torres
    replied to Query Question
    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...
    See more | Go to post

    Leave a comment:


  • John Torres
    replied to Query Question
    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!...
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Query Question

    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...
    See more | Go to post

  • John Torres
    replied to Query not Updating
    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...
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Query not Updating

    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
    See more | Go to post

  • John Torres
    replied to Query Question Linking
    Thank You very much.....It works....:>)...
    See more | Go to post
    Last edited by John Torres; Jul 9 '08, 06:54 PM. Reason: Problem solved

    Leave a comment:


  • John Torres
    started a topic Query Question Linking

    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!
    See more | Go to post

  • John Torres
    replied to Query Question
    Thank you very much...Now I got it......
    See more | Go to post

    Leave a comment:


  • John Torres
    replied to Query Question
    Where do i put the Query SQL and the Function... Sorry I'm a newbie and still learning...
    Thanks again.
    J...
    See more | Go to post

    Leave a comment:


  • John Torres
    replied to Combo Box orientation in Report
    Thanks again.. I will try to re-install office.
    See more | Go to post

    Leave a comment:


  • John Torres
    started a topic Query Question

    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 -----------...
    See more | Go to post

  • John Torres
    started a topic Combo Box orientation in Report

    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....
    See more | Go to post
No activity results to display
Show More
Working...