Hi :)
I'm trying to re-build a database that has become unweildy in Access and because it's Access it lacks scalability and some of the functionality we expect of it.
I've exported a tiny part of the data, and ended up with 2 columns
ClientID
CompanyName
Not all clients have a company name so there are a lot of blanks in the 2nd column. I've written a query to just show the non-blanks (=non-nulls) but now i want to make that into a table in it's own right. Is there an easy way to get a query to create the table for me or should i export as a Csv?
It's been a looooong time since i last wrote a database and then it was in Access. So, please try to forgive me asking a stupid question
Thanks and regards from
Tom