Recent content by rowzone

This has been answered in my duplicated post that I put in another forum This works by adding this to each currency field to calc correct value ( expr123: "£" & [Table]![Field] ) So at last I can start sending quotes out automatically without having to type them all out!! Full suggestion was...

This works ( expr123: "£" & [Table]![Field] ) Thanks, at last I can start sending quotes out automatically without having to type them all out!! Fantastic :)

The query being run is a make table query if that has any bearing on the reason for this not working? The original values from tables are stored as data type currency with format set as currency with originally auto decimal places, have changed this to 2 decimal places, but the table that is...

Apologies for the duplicate post, believed this was a better place for the post than the first one posted in queries, so that is why created two am new to this didn't seem to have an option to move the original post from one forum to another?

QuotesTbl Kayak_price Guided_price 2_man_total 3_man_total 4_man_total Kayak_total £27.50 £40.00 £0.00 £0.00 £0.00 £357.50 Data is stored as currency and displays correctly in table but doesn't covert over in word, so haven't been able to use it to send quotes for more than a year...

I am trying to run a mail merge using currency results from Access make table query going through Word to send emails. When running the merge the table result shows the correct currency figure, but when this appears in word it shows up as 13 x Kayaks @ 27 5 each = 357 5 Instead of...

I am trying to run a mail merge using currency results from Access through Word to send emails. When running the merge the table result shows the correct currency figure, but when this appears in word it shows up as 13 x Kayaks @ 27 5 each = 357 5 Instead of displaying @ £27.50 = £357.50 So...

Thank you for previous suggestions and apologies for very long delay responding. I now use Team Viewer to remotely access the database from smart phone ..did not think tablet idea was worth moving forward with .. works fine as long as I have a dataconnection

Hi I am a self taught access designer and have been designing databases for a number of years now as a sideline, but I am new to this forum. I am currently running 2007, but does it has the functionality to create Web Forms or is this just 2010. I currently run quite a complicated database...