Recent content by bplus

Hi, I have a java app connected to a MS access database. I need to run an sql command like "drop table if exists" You know, so it only tries to delete the table if its actually there. Im not sure how to do this with an access db. Also what is the difference between delete and drop. thanks v...

thanks, ill give that a go.

Hi, I ve got an access db thats attached to a java application. I need to be able to create a temporary table that stores a result set, its necessary to do this as the java app needs to perform lots of repeated operations on this temp table. I was think something like this would work: So i...

Hi, I need to create an sql query for an ms access db that will return the data type of a given column. Can anyone help me? I quite new to sql etc. thanks in advance!

I ve used the "simple query wizard before" but I cant see how to do counts in it. I tried the deisgn view query builder and cant see how to do counts there either.

Hi, Im very new to sql so please excuse my ignorance, I ve been trying to do this for a while and not getting anywhere: I have a table that has customer and product data in it. Its super market data. I have a field that has customer education level (education), this holds text, (bachelors...

thanks for all the help, got it working now.

Hi, Thanks for that. Is there any way I can save the results of query as a permanent table? The reason that I want to have it as a permanent table is that it Im doing some natural language generation stuff with it and it and if I just have one big table I can forget about sql completely and...

Hello first post here, I need some help! Sorry not sure if this should go under queries or tables. Anyway I'm working with quite a large access db (64mb). I want to merge data from several tables into one table. Its a supermarket db (not a real one). Its got a customer and product table Its...

Hello first post here, I need some help! Sorry not sure if this should go under queries or tables. Anyway I'm working with quite a large access db (64mb). I want to merge data from several tables into one table. Its a supermarket db (not a real one). Its got a customer and product table Its...