I have made a very basic programme in Access which has marks of different students in different subjects. I want to rank these students as per their marks. As...

I have a Name field that I would like to divide into 3 seperate parts? example: John W Smith Lisa Marie Jones I would like the the result to be 3 different...

Hello all, I've been trying to get my head round how to do this and completely failed. I've got a report which I can print off without any problems to a...

I just got Access 2007 the other day and I'm poking about with various functions, but, I want to do something and I can't figure out how to do it. I have...

Why would the following query copy one record into the history file anywhere from six to ten times? INSERT INTO tbl_History ( ID, ADJTrans, DRMOTrans,...

I have a form that gives the total hours worked each day, I would like to add all these up to give a weekly total hours it of course only displays up 24hrs,...

Perhaps a very simple question: When and why does one declare a record set? thanks.

Hi, Just Wondering if anybody can help me out! Im doing a timesheet database for our engineering department and in this timesheet it consist of 5 different...

I have a retail related DB and I realize that may not have thought through some design elements. It involves orders. I have an Order Table, A Order Detail...

Okay, I was trying to design a single table but ran into that pesky 255 column limit, so now I have multiple tables with multiple forms used for entering the...

Hi, my knowledge of access is fairly basic but have managed to build a form off a table using the wizards and gratefully searching these posts for explicits...

I'm trying to learn Access but I'm missing something very basic in here. I am to create a simple database to track sales. Product Table ProductId ...

I have created a table with 3 fields - last name / first name / & nationality. I have, so far, made 1 form which relates to one of those names in the list -...

I need to clear nearly all fields of a record without deleting the record itself , (57 out of 60) I thought a command button on the form would be a good Idea...

Hello All, I've been working on a database in Access 2007. It is used to track quality data for Printed Circuit Boards that are serialized. The form that I...

I am working on an Access 2007 application. We have a customer table which has a relationship with our State table. Originally, I was using a simple SQL...

Okay, using Access 2007, I have a beginner's DB design question... Standard stuff - for a financial management DB, in the Register, I need a way for Payees...

I need to create a database where I can enter all my customers. I would like to be able to click on a customer and have a new form open like word or...

Hi All I have created a user login form, where the users select his user name and then enter password and click go. On verifying the contents entered user is...

I need some help, i am a beginner when it comes to Access but have worked a lot with Excel. I want to create a database and forms/reports to use in a small...