To throw in or not?

[RainLover]

Sorry

But your drawing is no good to me.

Good luck with the project.

 

[nucoeus]

Hi Rainlover.

Sorry thought I was on the right track with that ERP?

If you would prefer it in another style I will be very willing to do so!

Your help has been very much appreciated to date!

Let me know,

nucoeus.

 

[RainLover]

Go back and read post #19.

 

[nucoeus]

Ahhh rite I see.

I most definitely will post the access database relationships however I haven't got that far yet!

I will structure it this weekend and post it up!

 

[RainLover]

Ahhh rite I see.

I most definitely will post the access database relationships however I haven't got that far yet!

I will structure it this weekend and post it up!

You should be doing this as you go.

Note, I do want your total database so I can drill down.

I am going Bush next week so I will be slow in replying.

 

[Lightwave]

Not sure that you really need me to fling my oar in but I will anyway.

PS My background is in accountancy - I wouldn't use excel anymore for fixed asset registers. In the long term you will get much more out of access.

Writing bespoke functions is similar whether you are in Access or Excel you need to just get round the idea of substitute fields variables for cell references and then proceed in a similar fashion while taking into account the idea of lines of unique records rather than unique cells.

Also as Rainlover says I would recommend you start defining the tables in Access and drawing the references between them. You will quickly see that some of your problems don't exist and you'll have a whole load that you hadn't thought about.!!