Search results for query: *

Hi there, The tool should be able to map Textfiles (of up to 1GB) to an MS-Access Table. Here are the rules for doing so: Field1 to Field5 of the TEXT-FILE are mapped to Column1 to Column5 of the DB-TABLE Field6 to Field16 of the TEXT-FILE are translated into an integer (through a black-box)...

Thanx so much for replying. I think your suggestion will definitly work. However due to the nature of my query, I was hoping to write this query within the database itself (for efficiency matters) In case you're wondering, here's the structure of my query: qry1: Field1 Field2 Field3 Sum 1 1...

Hi there, is there a way to make this query work? Select iif(fieldName=2, do_not_include_this_row, fieldName) From Many_inner_joined_tables cheers!