|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 19th, 2005, 11:23 AM
|
|||
|
|||
concatenate equivilent
Hi
How do I write expression eg 1 of 3 where 1 is field [count of rejects] and 3 is field [count of tested] in excel I would use concatenate but I don't know how to do in access TIA Tina 
|
|
#2
September 19th, 2005, 11:35 AM
|
|||
|
|||
|
=[count of rejects] & " of " & [count of tested]
"tina" wrote: Hi How do I write expression eg 1 of 3 where 1 is field [count of rejects] and 3 is field [count of tested] in excel I would use concatenate but I don't know how to do in access TIA Tina
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Distinct and Concatenate | Gwen H | Running & Setting Up Queries | 3 | September 8th, 2005 10:12 PM |
| concatenate type mismatch error 13 | kremesch | Using Forms | 9 | June 23rd, 2005 05:52 PM |
| Concatenate multiple docs into one and maintain original headers/footers | Mark Parent | General Discussion | 1 | September 30th, 2004 01:18 PM |
| Concatenate | Crystal | Worksheet Functions | 2 | February 26th, 2004 04:33 AM |
| Concatenate Conditions | Harlan Grove | Worksheet Functions | 0 | January 22nd, 2004 12:21 AM |
Linear Mode
