Combo Box Query!

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
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
 
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
 
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
 
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
 
Back
Top