plog's latest activity
-
Pplog 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...
-
Pplog 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...
-
Pplog 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)...
-
Pplog 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...
-
Pplog 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.
-
Pplog 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...
-
Pplog 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...
-
Pplog 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...
-
Pplog 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...
-
Pplog 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...
-
Pplog replied to the thread Solved Why Some Calculated Fields Will Not Work In A Query?.I'm not entirely certain your issue. So let me throw a few things at you: 1. You can't make a calculated field in a query and then use...
-
Pplog replied to the thread Select Statement Problem.Pasted it into notepad and counted characters. 6 opening parenthesis, 5 closing. So 3 steps: 1. Add a closing parenthesis at the...
-
Pplog replied to the thread Loop though a report.This is easier done in a query the report is based on than the report itself as you have suggested. You make a calculated field to...
-
Pplog replied to the thread DLookup Problem.How is that? Mathematically the count of the NULL set is 0. Mathematically the count of the set with only member 0 is 1. All sets...
-
Pplog replied to the thread Solved dlookup multi criteria.There's 2 different concatenation operators in play here. & : is used to combine elements of a string together ---> ("Hello " &...