feed a query from a table

[megatronixs]

Hi all,

I try to run a query that gets the results from table. the table has only one column.
in the criteria from the query I have referenced the table and the field name.
But when I run the query, I don't get results.
Any clue why this could be?
is there a easy way to do this?

Greetings.

 

[Ranman256]

That is the EASIEST way to make a query.
Grab the field and pull it down into the query grid.

Is the field marked to show?
Is there data in the table?
Is the query free of criteria?
Did you click the RUN query explanation mark icon?

 

[megatronixs]

Hi,

I did all the above. If I enter only one record in the criteria, it runs perfect.
I get the annoying parameter box asking for a parameter. what ever I do there, it will return no data.

really strange thing.

Greetings.

 

[megatronixs]

Hi,

I have the query like this:

SELECT PERSONAL_CUSTOMER_ID, CUSTOMER_NAME
FROM PERSONAL_CUSTOMER
WHERE (((PERSONAL_CUSTOMER_ID)=[tbl_related_id]![PERSONAL_CUSTOMER_ID]));

Greetings.

 

[Minty]

You have no Join to tbl_related_ID - so it has no idea what it is. Hence it keeps asking you for it.

 

[megatronixs]

I did the join, but the next problem is, that the query slows down and then times out on the server side.
Will just forget about this.
and just create a query based on a report. I will click on the field in the report from the customer name and then a report will open in the main report.

Greetings.

 

[Minty]

Do you have indexes on the fields you are trying to join?
If you join them you don't need the criteria at all.

 

[megatronixs]

I need to pause this one for a while as I will need to implement something else.
I guess in a few days or even few weeks I will get back to this.

Greetings.

 

[Tfa]

well that is a weird question
one table one column
well if you want the whole set of the table the sql query you want is this
SELECT * FROM table_name
now if you want some criteria you want this one
SELECT * FROM table_name where field_name = value
if its a char or string you will need this
SELECT * FROM table_name where field_name = "value"
it would be easier if i had the name of the table and the type of values that you use