SQL code for "predefined answers" (1 Viewer)

Mhelp

Registered User.
Local time
Today, 06:43
Joined
May 19, 2014
Messages
16
I have an access database I have uploaded to a SQL server.

However in the variables where I had predefined answers, it is not longer possible to choose from a list. It is possible to make the list of "predefined answers" in Access again, but for some reason it does that I can´t use the merge-mail function.

So is it possible to make the list of predefined answers to each of my variables in a SQL query?

Ex. I have a variable called "Stadium" and the list of answers should be "Metastatisk, Logo-regional, and Lokaliseret"

Can anyone help a newbie with programing this from start to end?
 

Rx_

Nothing In Moderation
Local time
Today, 07:43
Joined
Oct 22, 2009
Messages
2,803
Can you expand? Possibly use the Code tags to include the SQL Query statement and any other information that could be useful?
 

Mhelp

Registered User.
Local time
Today, 06:43
Joined
May 19, 2014
Messages
16
Sorry I don´t understand what you mean with expand and "Code tags"? Can you explain it to me even simpler :confused:
 

Rx_

Nothing In Moderation
Local time
Today, 07:43
Joined
Oct 22, 2009
Messages
2,803
In the Advanced reply mode for this forum - see the # button
click on that and you will see a
Open parens CODE close parens followed by a
open parens /Code close parens
place your SQL text in-between these two
That is how we post code samples or SQL statements here

it looks like this on the post:
Code:
Dim   MyNewForumUser
If MyNewForumUser Not FollowInstructions then
   IgnoreResponse = True
end if
 

Users who are viewing this thread

Top Bottom