Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
Access Concatenate rows into single rows: extra conditions needed
code_junkie
Nov 14th, 2011
62
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
text
0.17 KB
| None
|
0
0
raw
download
clone
embed
print
report
SELECT Number & Letter,
Concatenate("SELECT Letter & Alpha As FirstField FROM tblTable
WHERE Number & Letter =""" & [Number] & [Letter] & """") as FirstFields
FROM tblT
Add Comment
Please,
Sign In
to add comment
Public Pastes
load_dictionary
Python | 13 sec ago | 0.72 KB
ipp6_0_gallic_gambit
Python | 24 min ago | 3.41 KB
🤑 G2A.com Free Gift Card Guide Jun 2024 FIX 🤑
GetText | 48 min ago | 0.39 KB
🤑 G2A.com Free Gift Card Guide Jun 2024 FIX 🎁
GetText | 1 hour ago | 0.36 KB
Roe2Js :: Game Statistics
JavaScript | 1 hour ago | 1.59 KB
check.sh
Bash | 2 hours ago | 3.12 KB
510 mm/45 Type 98
Lua | 2 hours ago | 0.79 KB
508 mm/45 Mk.I
Lua | 2 hours ago | 0.74 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!