Search results for query: *

thanks! as you can imagine, i've moved onto the next problem: don't know if it relates so much to queries, (well it does in that i need to analyse two tables) so here goes: i have two tables: company and people. The link is the company field, which is text, a company name. I've put these...

meanwhile (and i'll probably post this as a new thread!): i have two tables: company and people. The link is the company field, which is text, a company name. I've put these two tables together separately, importing the data. I want to create a relationship between company field in one and...

meanwhile (and i'll probably post this as a new thread!): i have two tables: company and people. The link is the company field, which is text, a company name. I've put these two tables together separately, importing the data. I want to create a relationship between company field in one and...

good man! i watch as much premier league/champions league as i can, which is a lot in a county that shows BBC, dutch, belgian, french, italian german and spanish tv! however, alas, i am actually a Villa fan, so will most probably be watching Nationwide Div 1 next season!

aha, thanks. so what's a simple way of going about this? i just want basically to say if "e" then the value is 100, if "f" then the value is 200. thanks, neil

thanks chris!

no, in the table i've just got text . some fields are "cust" some are "prop" the query should convert these into numerical values. is this any clearer? in answer to your question kent - southampton - gloucester - bath and then emigrated to belgium, though i spend most of...

dear all, more calculations that are baffling me. i'm still playing with a query that will produce a number based upon text AND numerical fields. the text fields are confusing me. i have three variables, F, N and E. the expression i'm trying to build should return numerical value of 200 for...

dear all, does it matter if i submit to various google portals worldwide? i do a lot of business overseas and would like to get listed in uk, russia etc among others. should i just submit to one (eg. google.co.uk) or this plus .com, .ru etc. what effect will this have if any? many thanks! neil

hi! no, the table i am using for the query has text fields because this is useful elsewhere. i am trying to prioritise tasks based on several variables, INCLUDING whatever is in this text field. it could be various things, but if it is one of a couple of words like "cust" or...

........Well, complex to me. 1. I need to list records in my table in order of priority. for some fields i have a numerical value, so it's simple to build an expression. but for others there is a text field. for example a=100 , b=200 c= 300 how do i convert these values (or other text...