Search results

Well, I tried the first solution that Aroma KT suggested and it failed because ,once again, it would not let me choose any format. However, after playing with the syntax of the second solution (Spanish MS products have small differences - they like to make it hard!) it came up trumps and I now...

The odd name was a mistake....I wanted to put "It can't be that hard" but a single letter missed makes all the difference!! I will look into all the suggestions above and report back on the my success/failure. Cheers all!

I live and work in Spain and so the regional setting is already set to euros. I find it strange that if I leave A, B and C without euro format, why does Access not allow me later to choose a format for these numbers when I am making a report on them......?

Hello, I have a problem which I've mentioned before here but have yet to solve..... 3 fields in a query - A, B and C A is a column of previous expenditure in euros B is a column of current expenditure in euros C is is a column of A+B C, it seems, will only add A and B if there are amounts in...

I did actually have the currency firld selected but it did not work. I have now closed down the program and, on openng it, it now seems to be okay. thanks for the suggestion.

I tried this and, alas, in my format line it won't give me any options to choose from. Is this a bug from office 2003 or is it me? In 11 columns of numbers only 3 don't allow any format whatsoever.

My problems seem to be about the most silly things.... I have a table with various columns containing information in euros. For some reason it will not let me use cents because it always rounds them up or down to the nearest euro. I have gone into table design and changed the decimal places...

Hi, I have several tables with information about euros, a query relating to the tables and a report based on the query. Originally, to avoid problems, I produced all the information in numbers (without format) and later, in the report, went to the properties section and changed the format to...

I'm not sure I've been understood.... I have a table with various columns, all in the format of euros. When I create a query in which, for example, I add two columnss together, the resulting field appears simply as a number and not in euros. Is there an area in queries where you can select the...

I have a field in a query which does not come directly from a table and so has no format. I want to give 1222.34 the format "1,222.34€" for example but don't know where I do this in queries. Can someone fill me in? Thanks

Just found out the answer - no need for a reply!

Thanks very much for that advice, I've done what I think you wanted me to and it works for now. The only other question I have is that in the Nz function, rather than "0", I want "0,00€" to appear in empty cells but don't know how to do this ( Nz([YearTotal];0,00€) just gives me syntax errors...

I have one table with a list of 10 types of fruit. Another table details all the invoices throughout the year for these fruits. I also have 2 queries: Query 1 is an overall summary of the types of fruit with their respective profits gained over the period of a year. Query 2 is the same but for...

Thanks very much! I knew it'd be simple but got sick of looking without finding.

Hi, Not being any kind of expert, I have created a report using the Wizard and later have spent a while making changes to the layout which actually took quite a while for one reason or another. I am now aware that the information which appears in the printed report is ordered alphabetically...

I have a form which contains a subform. The subform has several columns of which one is "Expenses" and a box "SumExpenses" which keeps a running total in euros of this column. My main form contains a box "Total Expenses" which references this running total. The main form also contains a box...

I think what you have told me has worked just as hoped for. Thanks very much for the help!

I have an access form with a subform in it. The form is from a list of clients with their respective details and the subform is made up of calls made to each client with commentaries attached to each call. I want to produce a query which will, for instance, list all the client names plus the...

Thanks very much for that. Great help! Damie.

Well, in Table (1) I'd have Project Name (Primary Key), Town Name, Services and Value. In table (2) I'd just have Town Name (PK). If I change a town name in table (2) from, let's say Bristol to Malaga, I want table (1) to change all it's Bristol entries to Malaga as well (that is possible isn't...