Combo Box Query!

[Bob]

I have a table that list services and their price, I have a Query that puts
them together in a drop down combo list, so I can see the price with the
service. What I cant seem to do is have i.e.
Labour $10.00
Labour $12.00
I have to put a dot at the end of Labour. otherwise I can not get Labour
$12.00 to show. I have looked at the query and unique Values and records are
NO
Thanks for any Help .... Bob







..........Jenny Vance

 

[Perry]

MyCombo Rowsource =
SELECT [services] & " . " & [price] AS SP FROM MyTable

Krgrds,
Perry

 

[Damon Heron]

Your query should, when run, show only those with "labour" as the type, as
in this example:

SELECT tblTest.Id, tblTest.type, tblTest.Amt
FROM tblTest
WHERE (((tblTest.type)="labour"));

If that isn't happening, then post your query and we can look at it.

Damon

 

[Bob]

Damon the problem is that their are lots of Words that are the same but have
a different price , as the drop down list shows the price with the words, my
query
SELECT tblServiceInfo.ServiceInfo, tblServiceInfo.Rate
FROM tblServiceInfo
WHERE (((tblServiceInfo.ServiceInfo) Is Not Null) AND
((tblServiceInfo.ynMonthly)=False))
ORDER BY tblServiceInfo.Rate DESC;
Thanks,...Bob

 

[Damon Heron]

Service info consists of text such as labour, materials, etc., correct? The
field Rate is Currency? What is ynMonthly?
Will the query work if you just run this:

SELECT tblServiceInfo.ServiceInfo, tblServiceInfo.Rate
FROM tblServiceInfo;

If so, then the problem is in the Where statement. If not, then there is
something in the table that is goofy.
Sorry I can't be of more help.

Damon

 

[Bob]

Damon The Query works, but still can not change the Rate if Service Info is
the same as another, ynMonthly was from an early version not used now,
Thanks Bob