Get 1 field from 1 row Access 2007 VBA

[SBCUser666]

This is driving me crazy. I want 1 field from the first row of a table.

SELECT TOP 1 fielda FROM mytable



Every row in the table will have the same value in fielda. I just want to check to see if the value is correct. I really don't want to have to process a record set for 1 field.



Is there a way to do an in-line query for 1 row and how do I later reference the data returned?

[NeoPa]

If you simply want the value of one field from one record of a table then DLookup() will give you that.

In your case I doubt you'll need any criteria.

I won't go into asking about why you would have the same data in each record of a table. Sounds de-normalised to me (that's not a good thing). See Normalisation and Table structures.

[SBCUser666]

DLookup with no criteria worked great. Thanks!

I am just trying to automate a very manual process that uses 3 Oracle queries to extract data, import 3 CSV files into Access, 3 Access queries to update internal tables and then 3 Access queries to update 3 tables linked to a SQL database.

I am not about to normalize any of this.

[NeoPa]

@SBCUser666
You have to make the call of course. There are situations where normalising, especially retrospectively, is not worth the effort. They're pretty rare IMHO, but you're on the spot, so only you can make the call ultimately.