multiple queries as recordsource of report

[colenzo]

Hi Guys,

This is probably a really stupid question, but I can't seem to find any information about it on the web,

I'm attempting to design a report of which there a multiple queries as its recordsource, but I keep getting this error;

the SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.

Help!

 

[DCrake]

What is your Select statement?

 

[colenzo]

SELECT 
FROM [NON PUBLIC], [PUBLIC], [PUBLIC CUL];

Having never done a multiple query report before I have no idea what I'm doing - I just found a guide which told me to keep adding the queries I wanted to use.

Thanks for the help

 

[DCrake]

How are trying to build the recordsource? have you tried the query builder?

 

[colenzo]

There's a query builder???

The instructions I had was to go into the properties of the report - recordsource ... and add in the queries I wanted. I didn't realise there was any other way of doing it!

FYI I'm access 2000 and there are no installed componants (rolls eyes)

 

[DCrake]

When you created your report did you use the report wizard? If not why not?

 

[colenzo]

Unfortunately not,

I have no wizards installed - at all - I've been told by IT that we do not have the disk to reinstall the wizards so this is a no go as well - hence why i'm having to do it all manually.

If it's too much of a pain & long winded essay to explain etc, do not worry, i'll figure it out in the end

 

[DCrake]

Are you sure they are not installed or are they simply switched off?

 

[colenzo]

not installed at all - i've checked the file directory before - it must have been a skeleton installation.

 

[DCrake]

Beats me why youhave not got the original install disk. Could this be a pirate copy? (FACT)

 

[colenzo]

we lost a load of disks when we moved office's - nothing so exciting!

besides, we will be upgrading at somepoint in the most likely very distant future - but at the moment we're all stuck with what we have on the computers - it's at the point of it something comes in too new a version we have to open it using openoffice.

 

[colenzo]

Don't suppose anyone could point me at a decent guide, I'm still having a few issues with this and it recognising the fields used

 

[DCrake]

Open up you access application and down the left hand side there should be a list of buttons, Tables, Queries, Reports, etc.

Click on the Queries button, this should list any queries you have created, it should also have three preset actions at the top of the list.

Do me a favour, Press PrntScrn to take a picture of the screen and post it here for me to look at.

 

[colenzo]

Prt Screen as requested

 

[vbaInet]

It should be:

SELECT [COLOR=Red][B]*[/B][/COLOR] 
FROM [NON PUBLIC], [PUBLIC], [PUBLIC CUL];

NB: from the names of your tables I suspect you haven't normalized them.

 

[DCrake]

 

[colenzo]

after spending a week locating the disks I've finally got the wizard installed (despite mentioning otherwise) so could someone tell me why I still cannot do what I want to - which is run multiple queries in a report which all are based off the same table.

 

[vbaInet]

Let's see the SQL statement as it stands.

 

[colenzo]

It's posted from before,

To be honest, i'm now so fed up with access not doing simple things and having to go around in circles loading in wizards because I can't find a decent guide on doing it the manual way that i'm just going to go ahead and do the dam report in crystal reports and learn how to use that instead.

Thank you though

 

[vbaInet]

Did you see my post #15 regarding the correct syntax?