Recent content by showri

I have a table which has two columns: Startday Endday. I have two text boxes on a form one for week number and one for day number. I want to display current week number and current day. an example would be: if the semester starts on 5/13/2011 and ends on lets say 08/13/2011..I want to...

I have a table which logs in student sigin and signout times. What i am trying to do is to get is count of students signed in for every 30 minute intervals. Date 7:15-7:45 8:15-8:45 9:15-9:45 8/12/2010 1 0 3 8/14/2010 4 5...

Hi, I have a question regarding access query. If anyone can give me a an idea or provide me a partial query tht would be of great help. I have a student database which logs in students sign in and sign out time. Every student has a group and section. Basically it takes in the group and...

It is a Number and is entered manually (Not an auto number)

The Sales ID is a Number. Can you give me the steps as to how to design this kind of a form. Things I am looking for are: A form that display the records based on the query crteria. User can select the records that needs to be updated (how to do this?) An update query to update the...

Re: Select Multiple Records and Update At the Max there will be around 2000 policies, so I think it should not be a big problem to update. In the table the sales ID for each policy is stored manually (when a new policy is created). There is a seperate table which has the ID, The first name...

Select Multiple Records and Update Hi, Can anyone help me with the following Question? I have a table which holds different policies. Every policy has an associated sales person with it. The scenario is like this: If an existing sales person leaves and if we get a new sales person ( in...

I am designing a form which takes input form the keyboard and when the user pressess enter , based on the input the particular form opens up. The project is a student, teacher and a tutor database: when a student enters the id a student form will open up. the id starts with 00 when a...