Maniumplating Data on retrieval

Right here my Probelm. I have a dynamic drop down menu, which i am getting from a recordset called Parts. Simple SQL code

SELECT Description, PartID
FROM Part
ORDER BY Description

What i want to do, is place an "=" sign infront of all the PartID's. Is this possible

so instead of displaying 1,2,3 it displays =1,=2,=3

Any help would be great
thanks

SELECT Description, "=" & [PartID] AS PartID
FROM Part
ORDER BY Description;

By why? Normally only the Description is shown in a combo, not the ID number. Are you showing both the description and the partID? Why are you showing the ID?????

Basically i am using this to fill a dynamic drop down menu. The reason i want the = infront of the number is beasue i want to have a record which can select them all, i.e <>-1

This was the simplest way i could think to do it.

I tried that code and it does not appear to work? Can you confirm this is correct


SELECT Description,"=" & [PartID] AS PartIDS
FROM [Part]
ORDER BY Description

The last thing i should mention is i am using an access database. If that makes any difference.

Thanks

Quote:

---

Originally Posted by Vic

SELECT Description, "=" & [PartID] AS PartID
FROM Part
ORDER BY Description;

---

Quote:

---

SELECT Description,"=" & [PartID] AS PartIDS
FROM [Part]
ORDER BY Description

---

You could not see the differences between what I posted and what you posted?
The only difference that I see that matters is the "S" on the end of PartID.
But the big thing that is missing, is you say it does not appear to be working. Could you explain what is happening that makes it appear to not be working? Do you get and error message? If so, what is it and what does the message say? If you run this code and nothing happens, explain nothing. If all I know is it does not appear to work, I really have NOTHING to go on. Within reason, the more info you give us, the better chance we have of understanding what the problem is.

Hi

It simply says no value given for one or more require paramaters. I.e. it is not liking the "=" & [PartID] AS PartID part.

Thanks

I really don't want to give up on this, because I think I have seen a really great concept in your design. Could you show us the complete SQL statement for the dynamic drop down box, and give some details as how you want to use it?
Thanks,

Hi, some one else gave me the following code

SELECT Description, '=' + convert(varchar(20), PartID) as partid
FROM Part
ORDER BY Description

Whilst for some reason it did not like the convert statement, if i remove this and use

SELECT Description, '=' + (PartID) as partid
FROM Part
ORDER BY Description

it shows a list of Partid as "undefined"

Any Qlues??

Could you post a sample database that has this table and form in it so I can see what is going on?
Thanks,

If you use Vic's code
SELECT Description, "=" & [PartID] AS PartID
FROM Part
ORDER BY Description;
You will get a "circular reference error" as PartID cannot be an alias when it is also a field name.

The correct code is
SELECT Description, "=" & [PartID] AS PartIDs
FROM Part
ORDER BY Description;

Allan

Hi, with regard to the two codeas abov, neither of them seem to work.

Anyone know why? and can suggest a code that does?

Thanks

Quote:

---

Could you post a sample database that has this table and form in it so I can see what is going on?
Thanks,

---

I can tell from just the few posts I have seen of Allan Murphy he knows what he is talking about. I also know what I'm talking about. Now, two people that should be able to help you, have, but it is not working. I asked for a sample of what you are dealing with. If you would like to take the time to post that sample, I feel Allen, me, or someone else will be able to spot the problem VERY easily with SEEING the database.
Thanks,

Baisically, Part ID is a primary key and auto number in the part table

What i wish to do is select this, along with description (string), however, place a "=" sign infront on all the part ID's so it returns

=1
=2
=3

As opposed to 1,2,3

Is this possible?, if so, how??
Thanks

I have requested twice to be able to see the ACTUAL database, or a SAMPLE of the actual database. This would allow me to SEE with my own eyes what the code looks like. You have not even acknowledged that I have asked the question about seeing the database or a sample. But you do continue to ask the exact same question. I DO NOT know the answer. But, with the help of the visual of seeing the database, or a sample database, I think I have a very good chance of help you. Until you can address the issue of posting the database...

Ok, here is a sample of the table and some of the data in there.

That is very nice. I did say Database didn't I. or a sample of the DATABASE. Not pictures of the table and data.

Quote:

---

Right here my Probelm. I have a dynamic drop down menu, which i am getting from a recordset called Parts. Simple SQL code

SELECT Description, PartID
FROM Part
ORDER BY Description

What i want to do, is place an "=" sign infront of all the PartID's. Is this possible

so instead of displaying 1,2,3 it displays =1,=2,=3

---

This was your first post. It is referencing something that is somewhere, a form, a report, VBA code, or ?????? That is why I'm asking to see the DATABASE, not just part of it, not a picture of the table specs, not a picture of some of the data, but the DATABASE. That is where we will see what you have done, more than likely get a very good clue of what you are trying to do. Maybe you are very good at understanding what other people want when they say very little about it. I am not. I need ACTUAL details. Like the DATABASE.