Search results

Maosc, The simple solution. I love it. Problem solved. Thanks!:) Although I feel like a bit of a ditz! :( Thanks for taking your time to help a "special needs" guy. I also appreciate the lack of derogatory comments which I so obviously deserve in retrospect. :banghead: Woody

Thanks Beetle, I put your syntax in and it started returning other errors (no operator). You eluded to the fact I may be using the wrong approach. Let me describe in more detail what I am attempting. I have a query which has [GrossSalary] calculated field for each employee. I want to return...

I have a Dlookup which returns the correct value but returns the text of the instead of a numeric value. I have triple checked that the fields are all numeric. I suspect there is something wrong with my Dlookup syntax as it is my biggest weakness. Can anyone see in the following syntax what...

Plog, you are a Legend! Thank you for the explanation. I understand it now. I only had to add one additional quote to get it past a string error. But thanks to your explanation it was not a problem. :D The final working solution is below with an additional double quote in red: Expr1...

:banghead: I am trying to create a Dlookup in Access 2010 within a query using query wizard. I want to lookup the tax rate for an employee based on a salary range and their 'tax category' (string). Through troubleshooting I can get the criteria to work separately. These are...