access class microsoft training - access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access class microsoft training - Access

access class microsoft training - Access

resolvedResolved · Low Priority · Version Standard

David has attended:
Access Introduction course

Access

I need to change the year and move monthly sales figures along in our monthly Budget Reports.
Is there a calculation/formula that can be used?

RE: Access

Hi David

If you are familiar with SQL, you could use SQL update to update all the information. If you are not familiar with SQL, I would suggest using a macro.

Hope this helps
David

RE: Access

Hi David,
Thank you for your reply. Unfortunately it does not answer my question.
Please remember that I have done a beginners course. Therefore my knowledge is very limited.
What is a macro? This was not covered on the day.
What I don't understand is if I have a primary or index key already in the database why, when trying to save a form do I get the error message of " A primary or index number cannot be a null value"?
To use that well worn movie quote "Treat me like I'm a 3 year old" !
Look forward to your reply.
Regards
Dave Willis

RE: Access

Hi David

For you to firstly understand the issue you are trying to fix and then to solve it, I would advise coming on our intermediate course and then the advanced course. What you are trying to achieve is fairly complex and I think this would be the best course of action for you.

Hope this helps
David


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.09 secs.