Listbox Contents as Text Not Number

[andy_dyer]

Hi,

I have a listbox:

SELECT ID, [Project Name], [Client Name], [Project Estimated Hrs], [Project Value (Project)] AS [Project Value] FROM tblProject WHERE [Project Status]='Open' ORDER BY [Project Name];

My Query pulls out the detail for the chosen project to feed an Excel spreadsheet:

SELECT fGetListVals2("frmQuery","lstProject",1) AS [Project(s)], fGetListVals2("frmQuery","lstProject",2) AS Client, fGetListVals2("frmQuery","lstProject",3) AS [Project Estimated Hours], fGetListVals2("frmQuery","lstProject",4) AS [Project Value]
FROM tblProject
GROUP BY fGetListVals2("frmQuery","lstProject",1), fGetListVals2("frmQuery","lstProject",2), fGetListVals2("frmQuery","lstProject",3), fGetListVals2("frmQuery","lstProject",4);

BUT

The last item it pulls out of the list is a number a currency field to be exact and I really want it displaying with a "£" in front of it... I've tried changing the properties in the tables and all of the queries but it still exports as text in a number field... As a result even if i change the settings in Excel to currency it still loses the £...

Is there a way of fixing this that I am missing??

Sorry I know this sounds really trivial... but it's doing my head in!

 

[DCrake]

Andy

Replace

fGetListVals2("frmQuery","lstProject",4)

with

Format(fGetListVals2("frmQuery","lstProject",4),'Currency')

The space in C urrency is a visual bug not intentional

David

 

[andy_dyer]

Genius!!