Autofill data
Hey, is there a way to autofill some values in access based on a combination of other fields? Like essentially with VLOOKUP in excel. Specifically, I'm trying to autofill Latitude and Longitude fields based on a combination of Bay (location) and a Waypoint number for where we set nets in a lake. I have a deployment table I'm trying to fill everything in, and the only reason I need Lat & Long in that table vs just having it in the Waypoint table, is sometimes we set nets not along a waypoint and I want to be able to enter those coordinates. Attached are pictures of part of the Deployment form and the Waypoint table
Unique Field Format for a Calculated Field
I am trying to create a new Calculated Field in a table that populates the field in a specific format. The expression I am using is [Intake Date] & [Intake Count] is for a Field I named Intake ID. The new field will be used as the Primary Key for the Table which basically counts the record entries for a given day and converts them into a reference number. To illustrate an example, I want the combination of the Intake Date input of 2/14/2022 and the Intake Count (an AutoNumber) of 1 to read as 202202140001 in the Intake ID Field. This represents yyyymmdd####. I have played around with it a bit, but cannot get it to display the way I want. Any suggestions or examples would be greatly appreciated.
