Missing Operator

[abinjoseph]

I assume I am missing the JOIN portion.

Sorry, pretty new to access. Looking to find a value based on if it meets the two cireterias.

SELECT fldCOLA,
WHERE qryColaSalaryNum.COLA = COLArate.fldPercentage = qryColaSalaryNum = COLArate.fldSalaryRange
FROM COLArate;

I also want it sorted by qry.ColaSalaryNum.LastName and qry.ColaSalaryNum.FirstName


The value is in the column labeled fldCOLA. I am trying to replicate a VLookup in Excel here.

Thanks for your help...

 

[abinjoseph]

also, the equal in the middle is an "and"

 

[Galaxiom]

There is almost nothing right in your SQL.

Use the design view in the Access query designer.

 

[jdraw]

abinjoseph,

There are many sites and tutorials related to SQL and database. Use Google/Bing and youtube to learn the basics.
Here is a great starting point : W3Schools SQL

 

[The_Doc_Man]

In general, what you want will look like this once you are finished - so I will show a skeleton rather than the exact syntax.

SELECT field1, field2, ..., fieldn
FROM table-1
WHERE filter-1 AND filter-2 AND ...
ORDER BY primary-sort field, secondary-sort-field, tertiary-sort-field ;

If you are doing a JOIN between two tables, then that is part of the FROM line and before the WHERE clause. But look at the suggested tutorials first. Once you have a bit more on SQL syntax, you can get specific with us. But the question you asked us was fairly abstracted.