My Assistant
Site Message
(Message will auto close in 2 seconds)
  |
 Selecting Multiple Values Reates Multiple Records, Office 2010
|
|
 Mar 20 2012, 10:56 AM
Post
#1
|
|
|
New Member Posts: 4  |
I have a form where the user can select multiple Practice Areas in a drop-down box. However when I run the report for the records, it creates multiple records for that single entry. How can I get it to only show the record once no matter how many Practice Areas I choose. I tried to "Hide Duplicates" in the report but I can't do that in case there is another record that happens to have the same exact practice areas. Any ideas?
|
 |
 
|
|
Mar 20 2012, 11:00 AM
Post
#2
|
|
|
Access Wiki and Forums Moderator Posts: 47,928 From: SoCal, USA |
Hi,
(IMG:style_emoticons/default/welcome2UA.gif) You may have included the Value subfield of your multi-value field in your report instead of just the field's name. Just my 2 cents... (IMG:style_emoticons/default/2cents.gif) |
|
|
|
|
Mar 20 2012, 11:03 AM
Post
#3
|
|
|
New Member Posts: 4 |
I noticed that and tried it again (Practice Area vs Practice Area.Value) but it's still doing the same thing.
|
|
|
|
|
Mar 20 2012, 12:22 PM
Post
#4
|
|
|
UtterAccess Ruler Posts: 1,090 |
just a hunch:
Select YourTable.[Practice Area] From YourTable Where (Not ((YourTable.[Practice Area].Value) Is Null)) |
|
|
|
|
Mar 20 2012, 12:26 PM
Post
#5
|
|
|
Access Wiki and Forums Moderator Posts: 47,928 From: SoCal, USA |
QUOTE (mein46342 @ Mar 20 2012, 09:03 AM)  I noticed that and tried it again (Practice Area vs Practice Area.Value) but it's still doing the same thing. Is your report based on a query with multiple tables? If so, maybe you need to check the JOINs you're using? Just my 2 cents... (IMG:style_emoticons/default/2cents.gif) |
|
|
|
 |
|
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 20th May 2013 - 11:49 AM |