Search results

Hi, Hope someone can help. What I’m trying to do is have a combo box look up values from one table and add them to another. I have used the combo box wizard to look up a value from table1 and add it to table2 but is there a way that it can lookup 2 values and add them to the second table. For...

What I’m trying to achieve is a database that I can enter the number of calls a salespersons makes in a day. Please find diagram below. << Date >> ,,,,,,,,,,,,,,,,,,No-Calls Name Ben,,,,,,,,,,,,,,,1 Bob,,,,,,,,,,,,,,,2 John,,,,,,,,,,,,,,3 I have kind of got one working but when I...

Hi, I’m having a problem with the formatting of percentages, the report currently shows 100.0% as 10000.0% I found an article on Microsoft’s website that suggests I put ,"0.00%" after the sum. The problem is I already had a problem with 0’s in some fields so have had to put a longer string...

Hi hope someone can help, What I’m trying to do is work out price per quantity, at the mo I have a database that has products and price so lets take paint for an example. If I have a 5 litre pot of paint and I’m selling it for £10 I would like a field that tells me the price per litre, so...

Hi all hope someone can help I’m new to Access so hope I make sense. I’m writing a report that lists products, what I would like is for it to print so that if it’s in the middle of the detail lines start a new page. I probably haven’t explained my self very well so will try to illustrate...