Copy & Paste

[Harry Taylor]

Peeps, can anyone help?

I have a table with some visit history fields (Last Visit, Visit2, Visit3, Visit4, Visit5 & Visit6)

When I have visited a customer I cut and paste Visit5 to Visit6, Visit4 to Visit5, Visit3-4 etc then make a 1 line note of my visit in the Last Visit field.

Is it possible to create a macro that will Cut Visit5 and Paste to Visit6, Cut Visit4 and paste to Visit 5 etc?

Please help as I'm wearing out my Ctrl X & V Keys

 

[stopher]

This is the wrong way to design your database. Instead you should create a new table called tblVisits. This table will have customer as a foreign key so you will have many visits associated one customer. I would also suggest the use of a field such as VisitDate so that you can view the visit comments chronologically.

No more cutting and pasting.

 

[Harry Taylor]

Hi Stopher,

Thanks for the reply. I was thinking exactly the same and have created a Visit Table. However when I print a report I only want to see the last 6 visits. By creating a visits table I may have 30 visits which then wont fit in my report
I have tried limiting using Top Value but this limits the table to 6, not each record.