I have imported data from excel wrokbook and i've created forms. What i want is to cut and paste the entries from record 1 to record 2. is it possible? kindly help.
Novice
Windows 7 32bit 
Access 2007
I have imported data from excel wrokbook and i've created forms. What i want is to cut and paste the entries from record 1 to record 2. is it possible? kindly help.
VIP
Windows 7 64bit Access 2010 32bit
Can copy/paste. Can be a bit tricky. Do you want to copy the entire record?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Novice
Windows 7 32bit Access 2007
NO! I have around 800 entries and i want to merge/combine the first 5 records each into one single record. hope you can understand my lame explanation.
VIP
Windows 7 64bit Access 2010 32bit
Do not understand. Copy/paste is not synonymous with merge.
If you want to aggregate data (sum, average, etc) then build a GROUP BY (Totals) query.
Perhaps if you provide example of source data and example of desired output, can better advise.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote