|
|
Dropdown Query
Dear all, I have two columns. Each column contains a defined value and each
> value carries some predefined details. I am trying to place a dropdown
> through data validation, so that i select any value, i should be getting all
> the details related to that value without any extended space. Like below-:
>
>
> A operations
> A downtime
> a client figure
> B ratings
> B flow chart
> B technical support
>
> If i select A, I want to get the details of A as dropdown, i select B, i
> want to get the details of B.
>
I have also visited Debra Dalgleish site
http://www.contextures.com/xlDataVal13.html
But, my concern was unanswered.
Can it be done via OFFSET function or by any other function,please suggest
me.
I would be highly grateful to you !
Regards
Dharmesh
|
|
0
|
|
|
|
Reply
|
 Utf
|
5/17/2010 4:27:01 AM |
|
See http://www.ozgrid.com/Excel/dependent-lists.htm and download 2 demo
files.
--
Regards
Dave Hawley
www.ozgrid.com
"Dharmesh" <Dharmesh@discussions.microsoft.com> wrote in message
news:090DEBD6-1466-49E8-ABF7-844D3DA88C7F@microsoft.com...
> Dear all, I have two columns. Each column contains a defined value and
> each
>> value carries some predefined details. I am trying to place a dropdown
>> through data validation, so that i select any value, i should be getting
>> all
>> the details related to that value without any extended space. Like
>> below-:
>>
>>
>> A operations
>> A downtime
>> a client figure
>> B ratings
>> B flow chart
>> B technical support
>>
>> If i select A, I want to get the details of A as dropdown, i select B, i
>> want to get the details of B.
>>
> I have also visited Debra Dalgleish site
>
> http://www.contextures.com/xlDataVal13.html
>
> But, my concern was unanswered.
>
>
> Can it be done via OFFSET function or by any other function,please suggest
> me.
>
> I would be highly grateful to you !
>
> Regards
> Dharmesh
>
|
|
|
0
|
|
|
|
Reply
|
ozgrid
|
5/17/2010 6:14:35 AM
|
|
|
1 Replies
319 Views
(page loaded in 0.081 seconds)
Similiar Articles: IIf statement, wildcard to return all records - microsoft.public ...Hello, I am using an iif statement in a query criteria. It draws data from a dropdown box on an open form. The dropdown box has only 3 possible cho... DropDownList selected value - microsoft.public.dotnet.framework ...I think this is a basic question: I got a dropdownlist bind with a datasource, how do I get the value of the selected item? eg. Displayed text:... Update a Field Based on A Dropdown Selection - microsoft.public ...Update a Field Based on A Dropdown Selection - microsoft.public ... If the second question is true, use the After Update event of the combo to asign the value to the field ... Query criteria set by unbound form textboxes - microsoft.public ...How to use an unbound dropdown? - microsoft.public.access.forms ... Query criteria set by unbound form textboxes - microsoft.public ... I thought I would add a dropdown ... Remove dropdown arrow from read-only combo box - microsoft.public ...Is it possible to get rid of the dropdown arrow in a combo box and make it look like a text field? Wierd question, I know. Thanks! ... Create Form with Dropdown Combo Box - microsoft.public.access ...I want to create a form with dropdown combobox based off the Company Names. ... I have a query result that shows Company Names with their Financial Information ... Populating a text box from query results - microsoft.public.access ...I am new to Access programming and would consider my skills intermediate. Here's my problem: I have a form with three dropdown boxes that display da... Forms - dropdown - different font colors for each choice ...You would need a macro and you would probably need to remove the field shading, but it should be possible. Assuming the dropdown field in question is Dropdown1, run ... how do I use a dropdown list to update other fields on my form ...How do I create the dropdown list to perform that function? Please help!!! ... that information, include all of the fields that you want to see in the Query upon ... select multiple items from dropdown - microsoft.public.access ...... which is populated using a form. one of the fields is person's name, the dropdown for ... allen: thanks for responding to my query. i am going through your suggestion to ... Excel - Put Dropdown List In Query - Hopefully this... - Free ...Put Dropdown List In Query - Hopefully this is straightforward I have a query... - Free Excel Help PHP Tutorials Examples Dropdown Select With PHP and MySQLDropdown Select With PHP and MySQL Create Dynamic Drop down Selects By Kevin Waterson ... $result = DB:: getInstance ()-> query ("SELECT atomicnumber, english FROM elements"); ASP :: Dropdown Query List For Excel - BigResource: Webmaster ...Dropdown List This is probably really stupid, but I cannot figure it out, and none of the references I've found seem quite right for what I'm trying to do. Ajax Database Query With Dropdown Menu | AJAX MenuAjax Database Query With Dropdown Menu. Generate Fancy CSS3 Drop Down Menus in Minutes! No JavaScript, No Images, No Flash : CSS Only! Asp Menu Ajax Free dropdown - JSP Tutorials,EJB Tutorial,JDBC Tutorials,Free Java ...i want to use dropdown select value in query-string in same page.. Using selected 'name' want to fetch details of that person from database 7/15/2012 7:24:42 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 