Aceess query to SQL Server 1

[CRilliterate]

I think I was onse here told that I can convert my Access query into SQL somehow. I am searching but no avail so far...

 

[dhookom]

An Access query is a flavor of SQL. SQL Server has another flavor of SQL syntax. They are very closely related.

What are you searching for? What do you have and what do you need? Are you looking for specific syntax assistance?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CRilliterate]

I have a very lenghty statement written in Access that brings me tons of data.
I need to create view on SQL Server to use it instead of Access.
I actually already re-created everything manualy in SQL Server but it does not bring me a data.

I am puzzled now...any thoughts?
I did check all the links, even positioned for easy reading and copied screen to Word, printed out and matched everything Access has to SQL. Access uses linked SQl tables, so data is the same.

 

[dhookom]

I would recommend you start small by including just one table in the SQL view. Then continue adding tables and expressions until it "breaks".

If you can't figure out the syntax, consider posting a question in a SQL Server forum.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[CRilliterate]

Thanks, it is ok now. It was my mistake (as i suspected but tried to avoid responsibilities) LOL