Unusable field name

[JeroenMioch]

Hey guys,



Im importing a .CSV file using the import wizard.
The data im pulling from the file works great. However i want to display the date
the data is from (Not per se the date the file was created).

The date is in the csv file, however the import wizard creates its own field name.
The field holds the date, but the fieldname is......."Tijdstip";"Details";"Gebeurtenistype";"B ron"
Im not kidding haha
Its Dutch for "Time";"Details";"Eventtype";"Source"

Now, i tried to put that fieldname in brackets in my dlookup but access wont do that.

Any suggestion ?

[June7]

Which field?

The brackets should force the name to be accepted.

What does 'wont do that' mean - error message, wrong results, nothing happens?

Post the DLookup expression.

[JeroenMioch]

Hey June, thats what i thought.
This is the Dlookup :

Dlookup("["Tijdstip";"Details";"Gebeurtenistype";"Bron"]", "AEOS_telling")

The error is "Expected List seperator or )"

edit..

Tried it like this as well

DLookup(["Tijdstip";"Details";"Gebeurtenistype";"Bron"], "AEOS_telling")

Then im getting that acces cant find the field name im referring to

[JeroenMioch]

I made a workaround, im telling the import wizard not to use field headers.
Thus the first record is unusable. But i will just delete that record programaticly.

Still wondering if my question could be overcome though

[June7]

Your expression syntax is wrong. There are only 3 arguments and the structure is:

DLookup("[fieldname]", "[tablename]", "[anotherfieldname] = something")

[JeroenMioch]

So it needs the where clause even if i dont use it ?

[June7]

No, the where argument is optional.

Without it the expression will return value from first record. Why would you want value from first record?

There can be only 1 field in the target field argument, not 4. You can concatenate the fields but what does this serve?

DLookup("[Tijdstip] & [Details] & [Gebeurtenistype] & [Bron]", "AEOS_telling")

[JeroenMioch]

I wanted the first record actually, because the rest of the records return the same value (in that field).
The reason i want the field to exist is because this returns the true value of the file. Not its creation date, but the data the other field holds.

the fieldname "Tijdstip";"Details";"Gebeurtenistype";"Bron" is actually one field. And access created it, strange right ?

[June7]

Access created fieldname with quote marks and semicolons? Never seen that so just tried to build one manually and it did accept those characters. Had to do double up the quote marks in the DLookup so they would be accepted as literal text and not special characters.

DLookup("[""Tijdstip"";""Details"";""Gebeurtenistype"";""Bro n""]", "AEOS_telling")