Search results

Hi, I'm basically a SQL programmer currently working on Access. I don't see the feasibility of your requirement. What you want to do is conditionally select a column. This is possible on paper as you said. But in Access I doubt it's possibility.

i'm basically a SQL programmer only.. so this solution is very much in line with SQL.. the only difference being, here it is a query and there it is called a view..

forgot to add... this works only if D5>D3>D2>D1. :)

Hi Ebadin, I registered with this community for the sake of answering your query. Found it too interesting and tried it out, so that could provide you a solution. Here goes a detailed explanation of what i did. 1. Create a query that renames all the fields in your table. Thereby you have...