cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
miholmes
Engaged Sweeper
Good Morning!

First of all I LOVE this program. I work for a school district that has NO money and this piece of software is going to save me SO much time. As well as make sure we're LEGAL when it comes to licensing!

My question is this. I'm trying to write my own query in Access 2003 and it won't let me join the computer name field in the tblsoftware table on the SQL server because it says it's memo.

Can I change that so it isn't memo or will it mess up other items? I'm doing the query with another SQL table I have with computer hardware. Or is there a way I can change my OTHER SQL table to work with it? Please let me know! 😃

Thanks!

~MIke
1 REPLY 1
Hemoco
Lansweeper Alumni
as far as I know the field computername is varchar 300 in all tables, all you sure you are joining on the right field?
Maybe you can post your query here.