Hi
Is it possible to include a Dcount function in a query (qrySurveyDetail) to sequentially number records where a text field (ImageName) is not null?
RecordID
67
68
57
71
ImageName
Image
Image
No Image
Image
Dcount Number
1
2
Blank
3
The RecordID for each record, although unique, isn't sorted.
I'd like the query to have the ability for users to add to it or delete records and for the images to retain the sequence. ie If the record containing Image 1 was deleted, Image 2 would be renamed Image 1.
If this isn't possible with Dcount, any pointers on the SQL or VBA front?
Thanks
Is it possible to include a Dcount function in a query (qrySurveyDetail) to sequentially number records where a text field (ImageName) is not null?
RecordID
67
68
57
71
ImageName
Image
Image
No Image
Image
Dcount Number
1
2
Blank
3
The RecordID for each record, although unique, isn't sorted.
I'd like the query to have the ability for users to add to it or delete records and for the images to retain the sequence. ie If the record containing Image 1 was deleted, Image 2 would be renamed Image 1.
If this isn't possible with Dcount, any pointers on the SQL or VBA front?
Thanks
Last edited: