microsoft-access-course - Query - Replace function

The UK's most regular instructor-led training courses.
Training information: microsoft-access-course · Microsoft access courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Query - Replace function

Sabrina has attended:
Access Advanced course

by - delegate Sabrina [3 posts] (2007 Mar 13 Tue, 08:54) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Nov 26 Wed	Bloomsbury	3	book now	£224	£235
2007	2008 Nov 28 Fri	Bloomsbury	3	book now	£240	£245
2003	2008 Dec 3 Wed	Southwark	7	book now	£203	£230
2003	2008 Dec 19 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Dec 24 Wed	Bayswater	0	FULL
2003	2009 Jan 7 Wed	Southwark	7	book now	£203	£230
Full Schedule: See all 47 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Query - Replace function

by - trainer Richard platinum contributer [818 posts] (2007 Mar 13 Tue, 09:46) Reply

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

· Microsoft Access Training Opens Doors
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Convert a Paper Trail to a DBMS
· Access VBA Training Adds Power to your Databases
· Access VBA Handling Errors and Debugging Code

Access tip:

Hiding rows and columns

To hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column

View all Access hints and tips