Simple Query not returning any data.

[psoli]

Hi all,



Rusty as anything with Access, it had been about 6 years since I touched it, and then it was 2000.

I'm creating a database of stock which needs to be cross referenced against technical information sheets - however I've become stuck on the first Q, let alone the five or so others I need to write. I have a form, which calls this Q to pull information from a database, however even when using the wildcard and entering information that would definately return results, it doesn't return anything. Without the Form, it works :/

This is the SQL

SELECT mintexstock.[Product Code], mintexstock.Min, mintexstock.Max, mintexstock.Stock, mintexstock.POQty, mintexstock.Cost, mintexstock.Qtr, mintexstock.YtD, mintexstock.[2010]
FROM mintexstock
WHERE (((mintexstock.[Product Code]) Like [Forms]![Stock Search]![product]) AND ((mintexstock.Min)>[Forms]![Stock Search]![minstock]) AND ((mintexstock.Max)<[Forms]![Stock Search]![maxstock]) AND ((mintexstock.Stock)>[Forms]![Stock Search]![instock]));

Any pointers would be a massive help.

[June7]

This is a saved query object that is referenced in the form's RecordSource? Are controls bound to fields of the RecordSource?

[psoli]

This is a saved query object that is referenced in the form's RecordSource? Are controls bound to fields of the RecordSource?

The query is referenced in the form's RecordSource - the controls being?

[psoli]

Cheers June7 - I just found out that I don't actually need to run that query anymore because our other database can sift that information out for me.

Regards

[June7]

Glad you have a solution.

BTW, controls are the things placed on forms and reports - labels, textboxes, comboboxes, listboxes, subform containers, etc.