Search results for query: *

Thanks Bystander All AOK now much appreciated TonyNZ

hi there (again) can someone please tell me how when executing a query through a form, to treat blank values as zero i have a saved query that with Changeto calculates a dollar value that works fine running the query but not when you execute the query from a form unless all dollar fields have...

Hey again Joe I have figured out it is because the changeto is on dollar values and some of the fields were blank so didn't work unless all fields had a value, have set default in the table to $0.00 and it works but must be an easier way Funny it works whe you run the query and not through...

Thanks Joe, that simple huh and here I was beating my head against a brick wall Have another problem you may hlep with I have a saved query that is a changeto that works fine yet when I executeQBEFile through a button on a form it doesn't make the changes in the table what should i have as...

I have 2 identical tables but neither are keyed and can't be as get message tempory file too big when trying to key fields I want to add one table to another through a form but can't get it to work it works through the utilities add, and gives me the option to append, any help??

Thanks Joe

thanks Joe for responding i have set aup a table say with a field "type" that looks up another table "tree" with 2 fields both A20 first is code second field is tree say code A is for APPLE while editinfg teh table and I have set up tablelookup for the type field, when I...

Hey there Call me dumb but.. Having problems getting the lookup to fill in fields when in a form view for edit works fine on the table itself but when in form edit just the quick code i type stays there and teh lookup appears to work (ctrl space etc) but data not ok