Hi,
Any assistance someone can give me with this append querry issue is appreciated.
I have a table called tblRoleAssignments that has three fields RoleAssignmentID (PK), RoleprofileID & ApplicationrightID. It looks something like this.
RoleAssignmentID, RoleprofileID, ApplicationrightID
58, 12, 317
59, 12, 796
60, 12, 1
61, 13, 179
62, 13, 84
my append query will write new records depending on the RoleprofileID's I entered, for example If I run my append query on the above list I get the following output
RoleAssignmentID, RoleprofileID, ApplicationrightID
63, 0, 317
64, 0, 796
65, 0, 1
66, 0, 179
67, 0, 84
My problem is when I run my append query I want it to enter a specific value in the role profile ID column (taken ideally from a field on a form that will be loaded) so instead of the query entering a zero it writes to the table a vaule I want. Below is how I want my append querry to write the data if I wanted the RoleprofileID to be set to 35.
RoleAssignmentID RoleprofileID ApplicationrightID
63, 35, 317
64, 35, 796
65, 35, 1
66, 35, 179
67, 35, 84
Any ideas????????
Any assistance someone can give me with this append querry issue is appreciated.
I have a table called tblRoleAssignments that has three fields RoleAssignmentID (PK), RoleprofileID & ApplicationrightID. It looks something like this.
RoleAssignmentID, RoleprofileID, ApplicationrightID
58, 12, 317
59, 12, 796
60, 12, 1
61, 13, 179
62, 13, 84
my append query will write new records depending on the RoleprofileID's I entered, for example If I run my append query on the above list I get the following output
RoleAssignmentID, RoleprofileID, ApplicationrightID
63, 0, 317
64, 0, 796
65, 0, 1
66, 0, 179
67, 0, 84
My problem is when I run my append query I want it to enter a specific value in the role profile ID column (taken ideally from a field on a form that will be loaded) so instead of the query entering a zero it writes to the table a vaule I want. Below is how I want my append querry to write the data if I wanted the RoleprofileID to be set to 35.
RoleAssignmentID RoleprofileID ApplicationrightID
63, 35, 317
64, 35, 796
65, 35, 1
66, 35, 179
67, 35, 84
Any ideas????????