Sorry for any confusion.
Each rule may have one or more L1 and L2 owner. The L1 and L2 owner details are in table [OwnerL1] and [OwnerL2] table.
Let me know if this changes your advice.
sg2808
Last Activity: Jan 8 '13, 11:42 AM
Joined: Mar 8 '12
Location:
-
Design Problems With Too Many Junction Table, Please Help !
Hello,
I am having problems with the design of the database and being new to Access, I am wondering if I am doing things correctly.
I have the following tables:
1. [Rules], Fields - RuleID, RuleName
2. [OwnerL1], Fields - OwnerL1ID, OwnerL1Name (name of a person)
3. [OwnerL2], Fields - OwnerL2ID, OwnerL2Name (name of a person)
4. [Location], Fields - LocationID, LocationName
... -
Thanks twinnyfo but I am absolutely zero with VBA. Any help would be greatly appreciated.Leave a comment:
-
How to compare and identify data in array?
I have two columns which holds numerical values and both the columns are sorted.
I want to check if the data in the first column exists in the second column or not?
Eg.
Column A
1
2
3
4
Column B
1
2
4
5
I would like to check if the 1st cell value(=1) in Col A exists in Col B or not.
How can I compare and identify?
... -
In the design view, I selected the "Totals" and ran the report but I still have the same issue.
See the screen shot of the report....Leave a comment:
-
I am attaching the screen shots of my query and the releationship diagram, if this helps....Leave a comment:
-
How To Avoid Duplicate Data In Report? (Access 2007)
Hi,
I am having problem with duplicate data appearing in the report. I have selected all fields and in the property sheet I have selected "Yes" for the Hide Duplicate fields.
In the query design, I have selected "Yes" for the Unique records field.
I am attaching the report where you can see that the data is being repeated (circled in red).
Could you please advise how... -
How to know the target object for a button (created to preview report)?
Could be a very simple question.
How do I know which report a button is pointing to? The button was created to see a report (Preview report). I used the standard Access options that is available. I have not used any VBA code.
I checked the properties but could not find anything.
Thanks,
SG -
It is now finally working, the code used is:
Code:=DLookUp("Control_description","Control","Control_ref_number ='" & [Control_ref_no] & "'")Leave a comment:
-
Got it... I added "Is Null" in the Or field below.Leave a comment:
-
Thanks Rabbit.
Sorry, I am not good with SQL and I trying to use the Query Design view in Access to query the data. Not sure how to do this in the design view.
Yes, it is related to my previous thread.Leave a comment:
-
Just to add, the field is a text field and is not a numeric field? Will this change the code? If yes, what will it be?
Thanks,Leave a comment:
-
I removed the "[Me]." from the code but I then got an error, "#Error" in the text box.Leave a comment:
-
How To Show All Other Records When Using A Critieria In Query Design?
Hello,
I will give a simple example. I have a table [RuleMap]. It has a field called [Rulename] and[Ruletype]. [Ruletype] has entries like Handbook, Guidance and Legislation. Some of the records do not have the [Ruletype] mentioned against [Rulename].
I have designed a query in the Query design view. I do not want to see the [Rulename] where [Ruletype] is Legislation. I have used "<> Legislation" in... -
Correction - *once.
............... ............... ........Leave a comment:
-
I think I got the solution.. which is hitting the Escape key ones / twice.Leave a comment:
-
Thanks Nico, but I am not sure why this is not working? I have checked the Table and Field names which are fine.
Is there any prerequisite or conditions required for this to work?Leave a comment:
-
Error message for an indexed field on the Form
Hi,
In my form (with multiple tabs), I have a field which is indexed and does not allow duplicate data. While checking the form I found the following problem:
I entered a value in the field which already exist in the database. I then tried to save it but the database correctly warned to say that same data exists in the database.
I then tried to navigate away from the Form by deleting the value I entered... -
How to use "Unique Value" and "Count&quo t; in query design?
Hi,
In the design query, I have selected a field and I have marked "Unique Value" as Yes in the property. When I run the query I see 345 records. However, with the same settings, when I use Total function and set the Groupby as "Count", it then shows the count value as 688. Why is this so? It seems that the...Leave a comment:
-
How to count records in Many to Many scenario?
Hi,
I have two tables, [Rules] and [Process] which are in a many to many relationship via a junction table[JRule_Process]. It has the following field (relevant ones for this discussion):
[Rules]
RuleID
RuleName
[Process]
ProcessID
DetailProcessNa me
[JRule_Process]
JunctionID
RuleID
ProcessID
I have almost 5000 unique...
No activity results to display
Leave a comment: