Recent content by karmaimages

will try and PM you if I can markk

Sounds like a total nightmare, especially if whoever you're friends with can effect your score!

Im loving the 6s plus

It should indeed be legal

While that sounds great, unfortunately I know very basic access and need to get this up and running ASAP so don't have the time to learn about "normalization " or anything complicated like that. Any suggestions on how I can do this, as is will be great

Also have a query on the total remaining running total, why it's displaying #Type! ?

Thanks for the reply, unfortunately I need the balance stored to run some reports from the data. It's currently held on paper file manually calculated and updated - so really need the running total to update the remaining balance in the table

Hi, I've created a database to keep track of repayments from customers, which I've attached to the post for easier viewing. I'm not sure if I can post images yet which isn't helpful trying to explain this. From the form I have a running total of what is left to pay using the stating amount -...

Sorry I edited the post before you replied, it seems to be working now which is great. Second Query is it easy to display the total number of records in the work_items table - like a count of the "Surname" field as long as it counted duplicate surnames and or a total count of the Work Complete...

Actually that worked, not sure what I did to make it work, originally it didn't but entered the expression again and it seemed to work :) Thanks for your help

Hi, That still shows as #Error and I've entered it as above?

That works perfectly thank you. If I wanted to add a further criteria - Where field is Completed "yes" or "no" Would this be DCount("[Department]", "work_items", "[Department] = 'Sales' & [Work Complete]='No'") I did attempt the above but it shows as #Error?

Hi, I have a form where I want to show some statistics from the database like count how many bits of outstanding work there are for a certain department. I have a table called work_items - With various fields one being "Department" - I want on the form to display in a text box the number of...

http://www.access-programmers.co.uk/forums/showthread.php?t=183666 Not Sure if this might be a better place to post this, any help would be great :) Many Thanks

Good Evening I have attached the file below for reference. I have a form which im an am entering to keep a backup of a knowledge base. I need to be able to output each entry to a new word document and be able to save it as the document ID. I will be creating a simple html file to link to the...