Unrelated tables

[pomster]

I have a report with a date time field in it that I wish to filter by using an unrelated table with fields dtestart and dteend.
When I use the select expert I get an error or no data when changing the format to date. Is there another way?

cheers,



David

 

[synapsevampire]

How is a field going to use values from an unrelated table, if there's no relationship?

And if the field is a date, why would you be changing it's format to date?

Please post example data for all of the tables involved and expected output.

-k

 

[pomster]

I have a club database that has a single line/record table t_info showing various bits and pieces, name, address, secretary etc. these are used for report headers and footers.In this table i have dtestart and dteend for the current financial year. i.e.
dtestart dteend secretary address etc
01/07/02 30/06/03 David Australia etc
These fields are updated on a yearly basis.

I have a table t_payments for a report that shows payments, {dtepay} made on different dates. I wish to limit the reported payments to be within dtestart and dteend.
I hope this makes sense!

This used to work fine in access.

regards,


David

 

[synapsevampire]

OK, I think I understand your requirement.

Add the t_info table in twice, once linked to the
{dtepay} >= {dtestart}
and again with
{dtepay} <= {dteend}

Should work.

-k

 

[pomster]

Thanks for that, I added the table twice, one with a greater join and one with a less than join then used your formula in the select expert.


Thanks,


David