The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft-access-course - Query - Replace function

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

microsoft-access-course - Query - Replace function

Resolved · Low Priority · Version Standard

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

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?

For upcoming training course dates see: Pricing & availability

ReplyTue 13 Mar 2007, 09:46Trainer 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 articles

· Find Out About The Join Property In An Access Query
· Discover The Top Ten Changes In Access 2010
· How To Create A Combo Control On An Access Form
· Take an Access Course to Learn About Relational Databases
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips

When writing code, the best conventions for storing private and public variables, make it easier to call procedures. When passing codes to colleagues, everyone will understand the conventions.

» Forum post: Coding conventions and project structure conventions

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions