Search results for query: *

ok well i managed to get one of that databases to show up. by opening access by itslef then opening the database from there. my origional problem was that i was trying to bring up all of our customers who had spent money with us in the 2005 year and 2004 year. the SQL statement i thought was...

ok i posted in the access forums about not being able to .open the files but i managed to open one and find the customer database. now when you say table structure i am guessing that means the fields that go across the top? if so then there isnt another field for each visit. only lastin and...

I am trying to learn SQL to use Motor Marketing Machine for the shop I work at. Motor is an automotive shop program, part of the motor program is Motor Marketing Machine, which uses SQL to query customer data. Thanks to gmmastros in the microsoft server SQL forums we believe the marketing...

ok thanks, i found a dozen or so .mdb files in the motor program folder. when i open any one of them it shows no data, but its definately an access file. mabye ill just take this over to the access forums thanks again!

were using motor marketing machine its an automotive shop program...we dont have an actual SQL program, just motor marketing machine which incorporates SQL to search for customers. i have had success with querys like who hasnt been here for 5 to 9 months select * from customer where lastin...

im new to all of this and i dont believe we have a query analyzer, what is it and how can i get it to give you better information?

I have been trying to teach myself SQL for the past few days. I work in an automotive shop and we use Winworks Motor Marketing machine, which uses SQL. I have succesfully searched for and found some of the thigns i was trying to figure out using SQL but im stumped on this one. Basically I am...