Search results for query: *

thanks bob for your help. the database works great now. I was having a little problem with it not producing enough columns but you worked that out, thanks again for all your help.

email sent

scriverb: ok i did what you said and now im getting a run-time error on this line: rss.FindFirst "[Name] = '" & rs("Name") & "'" its saying its a syntax error (missing operator) Any ideas??

ok i understand what you are saying bob but all i really want is to run the query and then use the information it creates in other queries or forms. i really don't need any command buttons or anything like that.

im actually using bob's code first to see if i can get his to work. his uses more code that i know how to use. i dont even know where to begin on your code. I'm a very basic Access user and don't really understand where any of your code would be placed. I'm used to going to SQL View and typing...

ok this might sound like a basic question: I have all the queries made but i have no clue where to put the last bit of code you wrote...something about a temp table...where do i actually put that code?

thanks guys... i will give both those options a shot on monday when i go into work

i figured it was a basic query that i was just not noticing how to do it. THere is alot of records that would generate at the most 12 columns. maybe its more dificult then i originally thought.

I have a query set up and would like to make another query from that query. here is a sample of the query i have created: NUM NAME 1234 Adams,Joe 2743 Adams,Joe 2749 Griffin,Bob 4329 Smith,Bill 4876 Smith,Bill 4978 Smith,Bill And this is how I want the query to...