Recent content by weilerdo67

  1. W

    Forecasting a date based on working days.

    Hello, I hope someone can stir me in the right direction. I have a table that has a record that uses a Submittal date. I need to record a due date based on working days. So if I have a record that was created on 11/7/2024 and is due back 15 working days later ( 12/3/2024) so I need to create a...
  2. W

    Calculated field in form from another table

    Arnelgp, thank you so much for the help. This makes total since when I see how you broke it out. Big thumbs up...
  3. W

    Calculated field in form from another table

    Hello wonderful people. I am scratching my head trying to figure this one out. I have a form "Inventory" that is based on a table "Inventory" that stores Part Details (Part number, description, supplier, etc). I have a second table that stores transactions for a given part (IE addition, removal...
  4. W

    If Statement with multiple veribals

    Ok, that got me closer. It works for the >100 and the >32 it shows those correctly now but the <32 is still showing the wrong image. Here is the code I used from arnelgp Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) [img36].Visible=False [img32].Visible=False...
  5. W

    If Statement with multiple veribals

    Hi, Thanks for the replies I tried this and its showing all of the images. Is it because I dont have a False value? If Me.AvgOfTemp < 32 Then img40.Visible = True ElseIf Me.AvgOfTemp > 100 Then img36.Visible = True Else img32.Visible = True End If The...
  6. W

    If Statement with multiple veribals

    Hi, I think im doing this wrong and Im hoping someone can help me. I have a report that I want to have an image show depending on the value of a field. ON the report I have a field called AvgOfTemp and what I need is if the temp is greater the 100 show img36 if the temp is between 32 and 100...
Back
Top Bottom