Search results

ok, so I managed to get the solution that I needed. I created two queries for each Privilege. One to change it from a number to a text field "True" or "False" then another to change it from text to a boolean yes/no (checkbox). That gets me where I need for the privileges. However... now I...

Because they can have more than one privilege (and most all do) a listbox isn't very intuative for this. I'm trying to mimic a form that's hand written/filled out to make data entry easy. I've accomplished that with Table1. However, trying to import the data (and have it so that the data is...

ok, so how would I go about normalizing it? if I am to import this table from a flat file, how would I make sure that it is normalized? I can create a new table and add an autonumber on it, I still don't see how that'd help me.

So how would I accomplish this? Can I incorporate this into my Table 1? Set a conditional that says if(Table 1.EmpNumber = Table 2.EmpNumber AND Priviledge = 1, "Y", "N")? Will that go through the entire table and find all instances?

I have two tables I need to join. Table 1 EmpNumber | Privilege1 | Privilege2 | Privilege3 | Privilege4 Table 2 EmpNumber | Privilege In Table 1, EmpNumber is a unique primary key, in Table 2, there is no primary key. In Table 2, EmpNumber is repeated for each Privilege the employee...