Recent content by cathyc

Subtotal from a subform Hi Rich I have just got it to work and you were right it was a referencing problem as I had renamed the subform. Thanks for all your help.

Subtotal from a subform Hi Rich I have just got it to work and you were right it was a referencing problem as I had renamed the subform. Thanks for all your help.

Subtotal from a subform HI Rich I have tried what you suggested and all the references seem to be correct and I am still getting #Name? I even tried to knock up a simple, cut down version of the form and subform with new queries incase anything was wrong with the originals and still got...

Thanks Rich For replying. I have tried to change the control source as you stated but I am still getting #Name?

I hope someone can help me. I have a form called Project Summary on which I have created a subform called Payments Subform. On the form footer of the Payments Subform I have created a field called Core1Subtotal which calculates the subtotal of a field Core1. I am now trying to call the...

chart problem Hi Matt Myself and my colleague had the same problem with sample data displaying on the chart periodically when viewing the chart in preview mode and in design mode. On clicking on the chart again it seem to show the right data. Our problem seemed to lie with the way Access...

Returning value before null Thanks Rich I knew there would be a simple solution, I have fiddled about with the query and got it to return the right results.

I'm afraid not Colin, if I change the null to a zero, a zero will be returned for the last figure, (current job, new job or new business). I need a formula or code that will allow me to return the last value before a null, whilst also ensuring that the YEAR_NO's are kept in order so the last...

I posted a question re a query a few days ago, and have received no replies; to put it in more simply terms: I have two tables RDOTOWN and CRISPMON which are connected by Project name in a one-to-many relationship RDOTOWN holds project info and CRISPMON holds monitoring info for each project...

I wonder if someone can help me with a problem I am currently facing. I am trying to create either a crosstab or select query (which ever works best) which uses fields from two tables: RDOTOWN and Crispmon. The fields I need to use are project, town, crisp or cers (CRISP_OR_C), city or region...