Sabrina has attended:
Access Advanced course
Query - Replace function
I have run a query in Access in 2002 whereby I wanted it show several trade types to show "Borrow" positions. For borrow positions you would have 5 trade types. I do not want to show the trade types in a column but want to replace these with "Borrows". Any idea's how to do this within a query or would I have to create a macro/sql for this?
RE: Query - Replace function
Hi Sabrina
I am not sure if I understand your question. I think it about the relationship between BORROW and TRADE TYPES.
If you are looking to replace values, you can use an UPDATE QUERY.
So you can specify which values to select (ie. BORROW) and then put in the value you would like to update to. Bear in mind that this will update the actual values in the underlying table.
Let me know if that is what you are looking for, or if I misunderstand completely.
Richard
