Hi,
Hoping someone can help. I am trying to create a database to link to an online auction site (not ebay) and I want to create a query that randomly generates auction end time and auction length for all listings. I have tried int(rnd()) and various versions but can only generate the same number for all fields in the query.
Any ideas?
Its been 20 years since i last used access so its a bit of a relearning curve!
Thanks in advance for any info given
Generating a random time from list in query
Hoping someone can help. I am trying to create a database to link to an online auction site (not ebay) and I want to create a query that randomly generates auction end time and auction length for all listings. I have tried int(rnd()) and various versions but can only generate the same number for all fields in the query.
Any ideas?
Its been 20 years since i last used access so its a bit of a relearning curve!
Thanks in advance for any info given
0 commentaires:
Enregistrer un commentaire