Search results

Attached. I am not validating data from Access, the data is "Fail" data from another system, I need to find which fields exceed the max length for that system. I then need to make an idiot proof form so I can hand it over

I have 2 tables. Table1 defines the permitted field lentghs for Table2 eg Table1 NameOfField MaxLength Field1 50 Field2 20 Field3 20 etc etc Table2 Field1 Field2 Field3 Example 12345 54321 What I need to do is to query the data...

Unfortunately this did not work. There are no common fields between the 2 tables, "Call Data" is a table with 60+ fields, the other is a table with "call data"'s fields as entries. eg. Table - Call data: Number, Dialled, Cost, etc... 777777, 111111, 1.5, etc 666666, 222222, 1.2...

Possibly a simple solution to this, but I can't get my head round this... I have a table with 60+ fields, some are mandatory, some are not (we'll call this one call data). I have another table that defines whether the fields in "call data" are mandatory. What I would like to do is output any...