microsoft-access-course - Query - Replace function

Resolved · Low Priority · Version Standard

Tue 13 Mar 2007, 08:54 Delegate Sabrina said...

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?

Tue 13 Mar 2007, 09:46 Trainer Richard said...

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

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips

microsoft-access-course - Query - Replace function

Query - Replace function

RE: Query - Replace function

Access articles

Access tip:

Design View in Relationship window