DLOOKUP

[Guest]

Is that like VLOOKUP in excel? And is there just a LOOKUP?

 

[Guest]

Hi pgarcia,

dlookup is similar to a vlookup in Excel, but the syntax is different.
There is no "lookup" function in Access. What are you trying to achieve?

Damian.

 

[Guest]

Will, I do a report eveday and I use the VLOOKUP function to like so:

=VLOOKUP(D2,'[Stations.xls]All Stations'!$B$2:$B$1089,1,FALSE)

In D2 is state and then I look update that state for the city.

 

[Guest]

Something like this:

=dlookup("STATE", "CITYSTATETABLE", "CITY = '" & me.txtCity & "'")

Damian.

Will, I do a report eveday and I use the VLOOKUP function to like so:

=VLOOKUP(D2,'[Stations.xls]All Stations'!$B$2:$B$1089,1,FALSE)

In D2 is state and then I look update that state for the city.

Hi pgarcia,

dlookup is similar to a vlookup in Excel, but the syntax is different.
There is no "lookup" function in Access. What are you trying to achieve?

Damian.

 

[Guest]

Can I do that in a form with a table?

Something like this:

=dlookup("STATE", "CITYSTATETABLE", "CITY = '" & me.txtCity & "'")

Damian.

Will, I do a report eveday and I use the VLOOKUP function to like so:

=VLOOKUP(D2,'[Stations.xls]All Stations'!$B$2:$B$1089,1,FALSE)

In D2 is state and then I look update that state for the city.

Hi pgarcia,

dlookup is similar to a vlookup in Excel, but the syntax is different.
There is no "lookup" function in Access. What are you trying to achieve?

Damian.

:

Is that like VLOOKUP in excel? And is there just a LOOKUP?