Search results

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...

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 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

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...

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 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...

I'm sure this is already answered somewhere but didn't know what to look under to find it - sorry. Let's say I have a table (1) of a list of projects carried out in 5 towns. I also have a table (2) with just those 5 towns listed and a one-to-many realationship with table (1). I want to change...

I know I'm going to explain myself very badly, so I only hope someone knows what I'm getting at: You have a Table A with columns: Client (Primary Key), Country and Contact and a Table B with columns: Project (Primary Key), Client and Country (for example). If the relationship between A and B...

Hi, I'm just starting to get my head around the basics of Access, and am following a tuturial on using the iif function in Queries. I have a table with a "Credits" column, and with this table selected, I want to create a field which says "Full year" whenever Credits is more than 3 and "Half...