Recent content by hardy1976

I've been trying to solve that for about 3 months on and off! Query approach helped sooooooo much!

Got there eventually - using a function and query approach helped loads.

Sorry missed all the comments on here as I was trying to crack it - APPRECIATE ALL YOUR HELP EVERYONE

LOL - yes it was...

Wow - thank you.

Got it thank you all for your help "^\d{11}\/[a-zA-Z0-9]{4}\d{4}|^\d{11}\/\d{8}$"

Hi - got page could not be displayed... found it no s worked [url=http://thedbguy.blogspot.com/2016/02/extract-email-address.html]

Hi - loosely....

Don't know why these are not working - do only some regex expressions work in Access?

Hi, HELP - I need a regex expression that will test for... 11 digits then a "/" then either 8 digits OR 4 alpha/numeric followed by 4 numeric... egs 99039002885/AAAA0001 or 99039002885/00000001 I've got this but it doesnt work :( = "^\d{11}\/\d{8}$" Thanks

The_Doc_Man - Thanks, I will do this and have a look at invoicing on here. sneuberg - I was keeping the example simple, so I thought of an easy example. A football equipment hire place, you can hire pitches, goals, footballs etc. Teacher - $50 / session.teachers * session.hours * teacher This...

sneuberg post at 02-05-2017, 07:46 AM #18 sums up basically what I am trying to achieve - well it does it. If this is not the right way - please point me in the right direction. I really dont want this to be complicated!

The reason for this being in Access is so the data is all on once place and searchable/query-able. Thanks

All thank you for your advice, sorry for the lack of a response but I have had the lurgy and the last thing I wanted to do was look at my computer screen :) The last last last last thing i want to do i reinvent the wheel or make something more complicated than it needs to be. I like keeping...

Hi - thanks errr I'll try again. Table1 - Rates / Calc Football - $100 / session.footballs * football Goals - $30 / IIf((session.goals * goal)<$100,$100,$200) Teacher - $50 / session.teachers * session.hours * teacher Table2 - Session Session Number: 1 Footballs: 2 Goals: 0 Teachers: 1 Hours...