plog's latest activity

  • P
    plog replied to the thread Solved Filter Report.
    And there you go. See the misspelling?
  • P
    plog replied to the thread Solved Filter Report.
    This is not a datatype issue, it cannot find [days remaining]. Step away from the report. Open the query the report is based on. Does...
  • P
    plog replied to the thread Solved Filter Report.
    1. You don't need quotes around values when comparing numbers. 2. When compiling strings, you concatenate (put together) literal...
  • P
    plog replied to the thread Solved filter results in a query.
    Lots of questions and notes. 1. How far from tables are we? Building this query this way seems like building on an unstable...
  • P
    plog reacted to Pat Hartman's post in the thread Update Data Based on plat number and Date with Like Like.
    Is this a one-time effort to clean up bad data? There is no unique join available to you between the two tables, plus the tables...
  • P
    plog replied to the thread Not sure how best to display the information.
    I apologize, I thought that form was your Access form. However, I'm not entirely wrong. I think you need a Roles table. All the data...
  • P
    plog replied to the thread Not sure how best to display the information.
    You need to put away forms for now and work on properly structuring your data. That process is called normalization...
  • P
    plog replied to the thread Solved Sum If.
    Here's good documentation on IIf: https://www.techonthenet.com/access/functions/advanced/iif.php IIf(test, true result, false result)...
  • P
    plog replied to the thread What are the advantages of buying a TV instead of Monitor?.
    TVs and monitors are slowly merging. I don't use actual monitors any more. Monitor Pros: slightly cheaper, slightly simpler to use TV...
  • P
    plog replied to the thread Relationships.
    Combo boxes can be built without a separate table, you can look at existing distinct values in the field to choose from.
  • P
    plog replied to the thread Relationships.
    One big table. A good rule of thumb is that tables (and fields for that matter) should be named so generically that someone without...
  • P
    plog replied to the thread Relationships.
    It kind of seems like you are just building this by the seat of your pants and seeing where it takes you and hopefully that ending point...
  • P
    plog replied to the thread Relationships.
    No its not right. Computers and Drives should not JOIN on ComputerName. You should have the ID field of Computers to JOIN them...
  • P
    plog replied to the thread Relationships.
    From what I see it mostly looks good and only needs 1 table. The only advice I have is work toward numeric field when can. Capacity...
  • P
    plog replied to the thread Relationships.
    In general, entities and properties become tables and fields respectively. Cars are things and become a table. Make, model, year and...
Show older items
Back
Top Bottom