The first column is auto-incremented (primary key).
We would like the last column to be a counter which identifies each session regarding a port number and a connexion number.
Is there a SQL or Access function which would allow us to do that?
My application is protected with username and password. According to the user who has done the log in, some options will be available and some not.
Then, are there sessions in access?? How can I know who is loged in with which role otherwise?
My idea is to have a table, and say, loggin ok for the user X, but there may be one or more users at the same time. Then, how can I know which user is who if two are logged in in the same application by remote connection?
Hi All, We're currently rolling out 2003 Runtime and I've had a few users requesting multiple open seesions of the same database. I thought sure no problem, and then found that it doesn't look like it's possible with Runtime. Can anyone confirm whether there is a way around this?
It's just that they all had full version of 97 before and now were limiting them all to Runtime! :D
After long, long, long hiatus of doing other stuff, I wanted to get around to update the database. One thing I had set up wrong was the attendance rosters.I just need to be able to create a new class, which may have more than one sessions, then make a list of registrants for a particular class, then be able to track their attendance per session for this class.However, my Google-Fu is lacking as every templates I've looked at doesn't really answer my question, which how three entities relate to each other.I know for sure that Class-Attendees is a one many relationship. Same attendee can register for more than one class, so that's no brainer. Likewise, Class-Session should be also be one many relationship for obvious reasons. However, if I relate Session to Attendee, it would create a circular relationship between the three entities. I've toyed with the idea of having a hierarchial tables of Class -> Attendees -> Sessions, but that does not relate the sessions to the class, which is necessary. I wonder if I should create a fourth table to contain attendances and use Session and Attendees as FK, but that still wouldn't fix the possiblity of a circular relationship?Any insights will be greatly appreciated. TIA
I'm trying to return a list of students in a particular team who have not attended a certain number of sessions at a gym, between two dates. For some reason i get the error. At most one record can be returned by this subquery. (Error 3354).
SELECT [Student ID], Count(*) AS ["Number of Times Attended"] FROM Gym_Attendance WHERE [Gym Date] BETWEEN [Forms]![SV_Attendance]![txtStart].Value AND [Forms]![SV_Attendance]![txtEnd].Value AND [Student ID] Like (SELECT [Student ID] FROM Student_Sports WHERE [Sporting Team] = [Forms]![SV_Attendance]![lstTeam].Value) GROUP BY [Student ID] HAVING Count(*) < [Forms]![SV_Attendance]![txtNo].Value;
I have a module in my database that creates an appointment based on a table of sessions. The module works in all respects, except two:
1) When I declare optional attendees it sometimes shows them as required attendees in the actual meeting in outlook, but not always
2) The .Send method does not seem to work. It creates the appointment on my calendar as the originator of the appointment, but does not send to the other recipients.
Below is the code:
Code: Private Sub SchedOutlook() Dim rsEmployee As DAO.Recordset Set rsEmployee = CurrentDb.OpenRecordset("Select * FROM Employee INNER JOIN tblSession ON Employee.EmpID = tblSession.EmpID;", dbOpenDynaset) Dim rsMentor As DAO.Recordset
I have a report due the first of each week in which I need the cases open and cases closed for the previous week, the week two weeks prior and the 2007 and 2006 year to date on two different types of cases. I have a case management table with a field for Type of Case, date assigned and date closed that I uses in my queries. Presently I have two query, one that generates only Type 1 cases from the Case Management Table and another for Type 2. I then use the Type 1 Query in another query that limits the results for Type 1 cases to those opened last week, one for those open two weeks ago, one for 2006 YTD and one for 2007 YTD. In these 4 queries I have one field [Type of Cases] and I have the query count. I then do this for Type 2 cases and then go through the whole process to do Closed Cases. All my queries have criteria to automatically filter the dates to the time periods mentioned above. I then have one report query that I put all the number in for my report. This query has 16 fields with the numbers for each period, last week open and closed, 2 weeks open and closed, etc. I then generated a report that takes these numbers from my report query and puts it in a report format automatically. As you can imagine this takes some time to go through each query to generate these numbers, so I was wondering how I may do this differently. Also, I have experienced a problem when a field produces no records I get a blank sceen with nothing under the Count of column and get the same thing for my report. How can I fix this.
I have a form which displays which products are on sale but I want it to count stcok orders down, i.e. if there are 10 stock and someone orders 1 I want the system to automatically recognise that there are only now 9 in stock, any ideas? Help really would be appreciated!
I have a form called feedback which has three columns and each cell in a column has a combo box that holds (Yes/No/Empty), and I want to count each column's value for example let's supposed that:
feeback number: Column 1 (Are You happy) - Column 2 (Are you sad) - Column 3 (Are you hungry) 1 : Yes - No - Yes 2 : Yes - Yes - Yes 3 : No - No - Yes 4 : empty - No - yes
Counting: the next step is that I want to count:
values in Column 1, where number of Yes =2 , and number of No=1 the stum of Yes + No = 3 and empty = 1 values in Column 2, where number of Yes =1 , and number of No=3 the stum of Yes + No = 4 and empty = 0 values in Column 3, where number of Yes =4 , and number of No=0 the stum of Yes + No = 4 and empty = 0
So, how can I apply this concept in MS ACCESS (2000-2003).
I'm working on a database used to dispatch first aiders to events. The general structure is a form detailing the event with a subform (currently pulling info straight from a join table though I may change the data source to a query at a later date) containing details of attendees in list format.
I have a record in the events form that shows the number of first aiders attending which is currently updated manually. In the subform however, there is a tick box as to whether they attended as sometimes they enlist but have to cancel for whatever reason.
I wanted to implement something that will count the ticks and update the number attended field automatically.
I don't know alot about VB and have tried using the count expression function in the subform footer then setting the number attended field to equal the count field. The problem I find with this though is firstly there can sometime be a delay in updating this and secondly I need the number attended to appear in a report listing all the duties attended each month for expense claims.
I may be half way to hitting the mark with what I've tried but if anyone could suggest anything, I'd be very grateful.
I have a table which is basically a calendar containing the columns (i) date, (ii) special info relating to that date (iii) morning volunteers and (iv) afternoon volunteers.
In the "Morning Volunteers" there are up to two names with sometimes a first name, sometimes an initial but always a family name.
The same is true for the "Afternoon Volunteers".
What I want to do is, using the Family name, to find out how many mornings/afternoons each of the volunteers has manned the Visitor Centre.
As I am new to Access I have no idea whether this is possible and, if so, how to do it.
I can do it by exporting the table to Excel but this is very clumsy and time consuming
What I would like to do is get a count of the product sold and view it over a ten week period in this case week one starts 26th June.
Wk1, Wk2, Wk3 ....
x 10 5 15 etc y 20 4 12
in the format above but I am not sure how to achieve this, I have the following:
SELECT COURSEBK.[COURSE-DSName], COURSEBK.From, COURSEBK.Description, Count(COURSEBK.[COURSE-DSName]) AS [CountOfCOURSE-DSName] FROM COURSEBK GROUP BY COURSEBK.[COURSE-DSName], COURSEBK.From, COURSEBK.Description HAVING (((COURSEBK.From)>=#6/26/2005# And (COURSEBK.From)<=DateAdd("ww",+10,"26/06/05"))) ORDER BY COURSEBK.From;
(the above is working despite access changing the date format between the hashes)
Okay, this is gonna be weird :o What I'm looking to do is count the dates a preticular training task was accomplished. However, I do not want the dates that are expired to be counted. I will be running this off of a quiry that shows the "due date" of each task. I really have no idea where to start :confused: . Many thanks, Tim
I need a query that will display the social security number, and hte number of times it appears for each unique number. how would this be strucutred? thanks
could someone please help me. ive tried all sorts of things and now im loosing the will to live. under the data protection act i have 40 days to produce requested files in a hospital. the problem is that my little database that has been working away for 2 years is not capable of flagging up any files that are gone over the limit.
i need to run a query that will bring up all files not completed in the past 40 days. or reaching the forty day limit.
ive tried <now()-40 or <date()-40 in the critieria of the date rquested field. ive also tried kicking the machine when my boss isnt looking. that didnt work either.
Here is my table: tbl_tc Name Date Tech_Name Issue Resolved Resolved_Date In Out
I need a query that will do the following: Total Number of: Tickets Open (IE, Date field is populated, but Resolved_Date is not) Tickets Closed (both Date fields are populated) Total In Total Out
Total By Tech_Name: Same as above but I need it seperated by the techs name.
Problem is that I only need it to pull up the Current Months tickets, I will pull additional months later on.
I am not really sure how to even start this... HELP PLEASE!
I've attached a sample of what I'm trying to do. I want to count the number of hits in the column (each number represents only one hit). For example, Bill had a total of 2 hits. Please help me count the hits.
I need to run a query counting how many policies a client cancelled. But I need the query to include zeros. Is this possible?
Here's my SQL Statement currently.
SELECT DISTINCTROW Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS, Count(Pqry_CancelledPolicy01.Number) AS CountOfNumber FROM Pqry_CancelledPolicy01 GROUP BY Pqry_CancelledPolicy01.Number, Pqry_CancelledPolicy01.Name, Pqry_CancelledPolicy01.POLICY_STATUS ORDER BY Pqry_CancelledPolicy01.Number;
I have two reports i run every so often in those reports i have a criteria set which asks me to type yearly, lifetime or three year and then after report prints out it also has total member quantity query on top of the page which counts whatever membertype i am typing it in, however right now its only counting yearly members.
I was wondering is there an easy way to just count the yearly members, lifetime and three year separetly on top of my reports?
Quick overview. I have a site # and Subject #. The subject # is 7 digits and the first 4 are the site # (exp. Site # 1000, Subject # 1000001, 1000002, etc). At times the subjects switch sites but their subject # remains the same so Subject # 1000001 now resides at site # 2000.
How would I write a query like the following?
Count [tbl_Enrollment]![Subject #] WHERE [first 4 digits of the subject #] LIKE [tbl_Site_Dem]![Site #]
