How to view queries using the wizard in SQL view

I don't think this has changed. From design view, select View->SQL View

DHookum;

I brought up the Query Wizard and I do not find the SQL View or Design View on my 365 Office.

The Old NASA Kid put a bunch of old ones he had in my Windows 10 computer to reference because both of us have not worked with Access for a pretty long time, slowly but surely the cobwebs are coming out.

Thanks for being patient.

IchthyologistNeb

I never use the query wizard which is a feature that would never expose a user to a sql view. It's a wizard interface with the sole purpose of avoiding the SQL view. Create a query by whatever means and then view the SQL.

If you look at the screenshot Duane provided, you will see that Sql view is an option on the View pull down, when in query design mode.

Like Duane, I NEVER use the query wizard.

Actually, to clear this up?

For existing queries that you ALREADY made, even with the wizard?

It is ONLY AFTER using the wizard can you see/view the query and SQL view.

So, for all those existing queries you made (say even long ago)?

Then you can open up the query in design view, and then in ribbon choose SQL view.

So, say this:

However, WHEN you use the wizard? Then you can only view/see the SQL view AFTER you done using the wizard. (and even the older versions back in 2000 days worked this way).

So, with the wizard, you FIRST finish creating the query, and THEN you have a chance to flip over to SQL view.

eg this:

So, no big worry if you like and still use the query wizard - a lot of users do!

However, the "design" option(s), and the option to view the SQL?

You can only use that option AFTER the query wizard is done.

And of course for existing queries, then from the nav pane, just right click on that query and choose design. From that you can choose the view you want, including that of SQL view.

Dhookum;

I know I can do them with a form and an SQL which is what I have been doing, but the old query wizard was much faster.

I will just keep doing what I have been doing. You guys get upset with us, but when you send us images that are not the same as what we are looking at, which has occurred on several occasions it is discouraging.

While most of my friends know little about Microsoft, they are all very concerned about this constant downloading. Beleave me when I tell you they are outstanding security experts.

People keep telling us we are on older versions, when we are not!!!!

I went to DOS, found the directory and ran erase *.*, so how can they be.

Old NASA Kid

I finally found it, I had to click one home, and then views and it was about the sixth or seventh one down.

I am lucky I can remember anything about the 2003 days.

I am hoping the thing we may have to do after this one is comparing letters to the same image as English.

At least I do not think we will require any assistance for that.

I am not familiar with ODBC, we always had only one platform. Even 8 years ago I never had to go to a folder outside of Access.

I am getting upset because some of the guys do not realize what it is like dealing with so many small hospitals that have almost no knowledge, and in all honesty these computers are a mess.

Thanks, digging around can take a lot of time. Far more than we expected.

Old NASA Kid

OK; guys I found it, I might be able to save some time. I am very mad that individuals want me to follow this direction.

Before I decided to become a zoologist I wrote assembler programs for over 25 years, only 72 total instructions. You guys work with Access all the time.

When this is over I will never get involved with a computer issue again.

Downloads do not work. change directions because Microsoft Access cannot contain the image of a picture. Changes in terminologies, more words that Webster does not want to put into the dictionary.

I just got off the phone with Utrecht, in the Netherlands and the gentlemen informed me we had to get the size of the images, if they are small enough put them in an Access table.

I wanted to finish with this before my trip to Knoxville. We brought in an instructor from Texas Tech University. . He teaches Microsoft Access. His Comment, everyone talks about ODBC, but we could not find even one example with the code. In assembler it is

The book Microsoft recommended to the university does not even have one page of ODBC. I know computers, I designed the before my twenty-first birthday, I constructed them and even instructed hoe to build a compiler. There are other things I have accomplished I cannot discuss. It is dd srv (Server Number) and stays there until you move to another server or director. Why has Microsoft made this so complicated?

The syntax of the instructions as always bee a problem for me. The gentleman from Utrecht, said to look at some other open source programs. He talked about some companies using a new business language developed in North Dakota, that no one in NASA knows about. It is being used in Europe, but apparently not the United States

What upsets me the most is that Microsoft wanted to become a giant and when people tell me I am still on Access 2007, where it appears there were some major issues and I cannot find it in my computer, there is a serious problem.

I could convert the work Access and do a byte by byte search on the disk drive, but I have to get ready for my trip to Knoxville after today.

IchthyologistNeb

Thanks for showing me were too find the SQL in the query wizard.

No one answering any of your dozens of questions has ever mentioned anything about ODBC. That should tell you that ODBC has absolutely nothing to do with your application that is all MS Access.

Thank you that is very good to know. From reading so much stuff on line I was under the impression if it was outside the database special things had to be done. The guy in The Netherlands thought the same thing.

I really feel good for the first time in two weeks!

IchthyologistNeb