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

Access

resolvedResolved · Urgent Priority · Version 2007

Samantha has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Access

Hello I was wondering if you could help:

i have a form containing 'service information' on equipment at offices like fire extinguishers etc (includes date of last test, equipment provider, Supplier, equipment type and period of review)on 'equipment' at 'offices'.

I also have a subform which shows the (all) 'date of the last test' for this product. i want the two forms to work together so i can enter a date in the 'date of last test' on the main form and it will enter it as a new records on the subform and store the prevoius date still in this subform. is that possible?
Thank-you

RE: Access

Hi Samantha

Thanks for your question, as it relates directly to your own database we may well need you to provide more detail on what you are trying to achieve before we can be confident of giving you a correct answer!

It may well be a quick solution or a more involved consultative approach that needs to be taken.

I will email you separately and if you can reply that will be great.

Regards

Jacob


 

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.



Access provides an easy method of achieving a running total.



Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips


Server loaded in 0.08 secs.