Hi all, I'm trying to create a function for my Access 2003 database.
Function RelativeStatus( )
Dim Present As Double
Dim Past As Double
Present = [tblFleetRecent]![Actual]
Past = [tblFleetRecent]![LastWeek]
If Present > Past Then
RelativeStatus = "increase"
ElseIf Present = Past Then
RelativeStatus = "static"
...
M3lancholy
Last Activity: Jan 23 '07, 11:54 PM
Joined: Jan 18 '07
Location:
-
Help!! Table Field References
-
Update Query hidden records?
I've created a database in Microsoft Access 2003, Windows XP.
It updates based on: a date range, and various other field matches.
It takes this data from a form.
What I'm confused about is that every time I run this update query, an additional "phantom row" is updated. I know this because the warning pops up with "You are now about to update 4 rows" . Then next run it says 5. And so on. I was wondering...
No activity results to display