dannylam4
Last Activity: May 16 '08, 01:31 PM
Joined: May 10 '07
Location:
-
Ahhh, well that certainly makes more sense... I thought that Code was doing the same thing as the SQL code, but with VB. I got the concat working though! Thanks a lot for that. And... everything looks great! Thanks a bunch guys, I appreciate the help. Curse me for not reading enough, huh? Haha -
Right, I realize this; this is just a small snipplet of our database. I suppose, in order to make it more logical, we would have a personID. So... it'd be something like:
Name - - - Address - -Email - - - - -Comments - - ID
John Doe - 11211 - - - j2@g.com - lad - - - - - - - 1
John Doe - 41541 - - - q3@g.com -asd - - - - - - - 1
John Doe - 12345 - - - w2@g.com -ask - - - - - - - 0
...Leave a comment:
-
Merging Rows with Similar Values
Hello, I've got a question about merging/concatenating rows. There's a similar topic here: Combining Multiple Rows of one Field into One Result but I didn't know if I should hijack it. Basically, I have a single table in Access that looks like:
Name - - - Address - -Email - - - - -Comments
John Doe - 11211 - - - j2@g.com - lad
John Doe - 41541 - - - q3@g.com -asd
John Doe - 12345 - - - w2@g.com -ask
... -
Heh, nevermind, it seems that I wasn't able to see the tables because of certain right issues. Thanks for all the help guys!Leave a comment:
-
You can't happen to explain what an ODBC is can you? Or how to create one? I'm pretty lost on the subject, and I'm asking the admin of the SQL Server and she has no idea what I'm talking about. We're creating our tables in Microsoft SQL Server's Enterprise Manager, and I'm in Access, I found the server name, and connected to it, but I found no tables....Leave a comment:
-
Connecting to SQL Database
Alright, so the company I'm working at has currently decided that they're going to convert their Access (2003) databases to SQL Databases; that's all simple enough I suppose (that's not my job), but they want to keep their Access as a frontend and the SQL Database as the backend.
So basically, what I'm asking is is there anyway to pull the data from the SQL Database and display it in Access?
No activity results to display
Leave a comment: