Search results

Hi You very clever people out there ... please help. I have two tables which I need to change stock levels. I have one table that has the stock levels as of now ... and another table that shows stock levels from yesterday. I need to produce a txt file so that it checks both stock levels and...

I have a contact database which I want to archive items - I have created a field called Archived and as a Yes/No field. So everytime a contact has been assigned a YES I want "Archived Contact" to flash so that its easy for people to see! Im sure its really easy ... but Im stupid! HELP...

I have one table with the following address1 address1b address1c town county postcode AND feepayeraddress feepayeraddress2 feepayeraddress3 town county postcode. The question is users are filling in the address fields but want to hit a button on the form so that it copies the contacts...

Need help .... I have a database which has two sets of address fields in one table. One address set is for a client and one address set is for a feepayer. Are you able to create a button that copies the client address fields and populates the feepayer address fields (with the same data)???

How can you create a dropdown field with 20% through to 30% so that the prices increase by that amount?

Is this possible???? I have a field in my report called LeadSource which in the table holds one letter A, B ,C and so on. Can you set an expression to say when A appears show Apple or when B appears show Bear (just as an example). I have linked a decode table to the main data but its running...

This is driving me crazy, with my muppet knowledge! I have a report which has the following fields Application Count Hit And Miss Count Sale Count I am trying to do a percentage from Hit and Miss Count plus Sale Count / Application Count I put it in an expression on the report but it shows...

I have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different...

I have created a form from a table and only the startup screen when I hit the button I want the form to display a clear entry so that I can create a new contact each time - at the moment when i hit the button it shows the first record and im in danger of changing it (im having to hit the create...

I am running a query to find out duplicate in two fields in one table. Postcode and Address Line 1. Can anyone tell me the formula for only picking up the first 6 charaters in the Address Line 1 field??? I cant remember how to do it! HELP!