Hi.
I've got a little head scratcher here which i'm hoping someone can help with.
I have a table with several fields in it which cater for 60'000 records or so. The table is like this:
ID Field1 Field2
----------------------------
0 'SomeText' 'SomeText'
1 '' 'SomeText'
etc
I want to call a query that returns the ID number and then a 1 or 0 (or true or false) if the column contains data.
e.g.:
ID Field1 Field2
----------------------------
0 1 1
1 0 1
or
ID Field1 Field2
----------------------------
0 True True
1 False True
I will probably also want to filter this as well to exclude text phrases such as 'none' or 'n/a' etc.
To add to this I'd also like to return the data from several tables (which are all referenced by the same id in the same way) at the same time, but rather suspect this will be too much?
e.g:
ID Tbl1.Field1 Tbl1.Field2 Tbl2.Fieldx Tbl3.Fieldx
--------------------------------------------------------
0 True True False True
1 False True False False
Any ideas?
Thanks.
Jeff
I've got a little head scratcher here which i'm hoping someone can help with.
I have a table with several fields in it which cater for 60'000 records or so. The table is like this:
ID Field1 Field2
----------------------------
0 'SomeText' 'SomeText'
1 '' 'SomeText'
etc
I want to call a query that returns the ID number and then a 1 or 0 (or true or false) if the column contains data.
e.g.:
ID Field1 Field2
----------------------------
0 1 1
1 0 1
or
ID Field1 Field2
----------------------------
0 True True
1 False True
I will probably also want to filter this as well to exclude text phrases such as 'none' or 'n/a' etc.
To add to this I'd also like to return the data from several tables (which are all referenced by the same id in the same way) at the same time, but rather suspect this will be too much?
e.g:
ID Tbl1.Field1 Tbl1.Field2 Tbl2.Fieldx Tbl3.Fieldx
--------------------------------------------------------
0 True True False True
1 False True False False
Any ideas?
Thanks.
Jeff