Each licence agreement can have one or many licence keys, each licence key can have one or many licences
I would like a query that groups by LicenceAgreementID then sums the NumOfLicences for the the LicenceAgreementId.
Query so far:
SELECT tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
FROM tblLicenseDetails
GROUP BY tblLicenseDetails.LicenseAgreementID, tblLicenseDetails.LicenseKey, tblLicenseDetails.NumOfLicensePurch
HAVING (((tblLicenseDetails.LicenseAgreementID) Is Not Null));
It may be that I have to redesign my tables, if so I will will.
I am in the process of creating my first commercial databse and i was wondering if anyone new where i can get a template of a generic user licence text?
At our firm we have a mix of Microsoft Office (2000) Standard licenses and Microsoft Office(2000) Professional liceneses.
After reading through a lot of literature from Microsofts own site it is possible to create Data access pages to enable users to view and have basic inputting into an access back end database.It also states that you need a qualifying License to use microsofts 'web components' to be able to do this.
Now another of our offices has decided to 'check' with microsofts helpdesk about wether or not you need a seperate access license for each user and suprise suprise Microsoft state you do.
Their own site states that Office standard IS a qualifying license see here
Anyone know if i am commitiing an offense or am i just being bullied by microsoft.I have asked them to produce the legislation that states i am doing wrong but they have not yet responded
I recently bought a new computer and it was kinda cheap, so no office products were installed on the computer. A friend loaned me her copy of Office 2003 which didn't have Access on it. So, after installing Office 2003 I picked my old Office 97 CD and installed just Access 97. Then I go to open the database and get this annoying message.
Microsoft Access can't start because there is no license for it on this machine.
I am developing an Access database, and using the Access 2007 Developer Extensions to "compile" it into an installable program which includes the freely distributable Access 2007 RunTime, for users who don't have it already installed.
I am planning on charging a subscription fee to use my Access database. Are there any existing method for handling making sure the user's subscription is still active, and if not, either locking them our or preferably making everything read-only? If there aren't any existing methods anyone can point me to, does anyone have any ideas?
I plan on being the person who installs the application the first time, however I'm sure instances will come up where I instead mail the user a CD for them to install.
Regardless of whether I complete the first install, I'm not interested in going to each users' location periodically regarding the subscription.
I'm more interested in going the route of the user typing in some type of registration code, which is validated for read/write access for a period of time.
I don't want to rely on the user having an internet connection, but if they had one, I could certainly go the Microsoft model (try internet verification, if it goes wrong or there isn't a connection, have user call in.)
Basically, I have a database table that is maintained every week. It is about e-mail account licenses for Office 365.
Each column represents a week of license data for every mailbox account which is about 10 000 plus users with the date as the field headers( something like "License information as of 06122013").
Basically, I have created 52 queries based on the license type I require to be calculated & I have a form created to control it. However, right now it is all output only as I have yet to create any user parameter to specify on any of the queries about the date I want
As I am currently unsure how to specify all the queries to use one field date header which I want the user to specify via drop down list in order to calculate all the licenses on this specific date.
For example, if I want to see the license information for 06/11/2013, I would choose "License as of 06112013" & it would then run all the queries based on the header specified earlier & output that information on the form.
Right now the queries are all configured as the "Select" type.
Trying to use Access97 on Windows XP and I get an error message.
"Microsoft Access can't start because there is no license for it on this machine"
I've tried everything and it still doesn't want to work. I've uninstalled and reinstalled I've tried to find the font, hatten, and it's not there I've downloaded MDAC 2.8 I've check the permissions in HKEY CLASSES ROOT I've tried c:setup/y I've downloaded AcLicn97.exe and it tells me that it can't find Access
In this table it has a bookingID, CustomerID and some other none relevant details.
The CustomerID comes from table tblCustomer. i.e a customerID must exist in the customer table to be allowed in the bookings table tblBookings
A customer can exist in tblCustomer without existing in the booking table.
I am trying to write a query that will list each and every customer ID in the tblCustomer and count the number of bookings that that customer has (even if it is zero).
I have a query that will count the bookings if they exist in the booking table and display the number of times that a customer appears in the bookings table.
SELECT tblBookings.CustomerID, Count(tblBookings.CustomerID) AS NoOfBookings FROM tblBookings GROUP BY tblBookings.CustomerID;
How do I create a query that will do this but list all customers even if they don't exist in the bookings table (but obviously occur in the customers table)
I am trying to create a similar query where all bookings per hotel are listed even if no bookings are made for that hotel. I am guessing the answer is the same as above.
The Ritz. Bookings 0 The Hilton. Bookings 3 The Carlton. Bookings 0 The Lowry. Bookings 2
The journal ID above was an accounting entry, debit $16,797 and credit $-16,797. because it was entered as a reversing journal in the system, the table has captured the Journal ID with 2 dates. For my purpose i only want the one date (MIN) date, the total amount of the journal (either the debit or credit amount 16,797) and the total number of lines the journal ID has so in this instance I want the count to be 2 and not 4.
Im thinking with the total sum because theres debits and credits is there a way to do the absolute value of the journal MONY_A then divide by 2?
current SQL SELECT [One Year Data Lines].JRNL_I, [One Year Data Lines].CNCY_C, Count([One Year Data Lines].JRNL_I) AS CountOfJRNL_I, Min([One Year Data Lines].JRNL_D) AS MinOfJRNL_D, [One Year Data Lines].BUSN_UNIT_I, Sum([One Year Data Lines].MONY_A) AS SumOfMONY_A FROM [One Year Data Lines] GROUP BY [One Year Data Lines].JRNL_I, [One Year Data Lines].CNCY_C, [One Year Data Lines].BUSN_UNIT_I HAVING ((([One Year Data Lines].JRNL_I)="0002888269") AND (([One Year Data Lines].CNCY_C)="aud"));
Just spent the past hour in here trying to nut this one out, but not sure I've found something quite the same...though I know the answer will be painfully simple.
I have a customer table and a product table, and a query that groups customer first and last names along with a count of products per customer e.g. 1,1,3,2,3,4,2,1 indicates customer A buys qty 1 of product z, customer B buys qty 1 of product x, cust C buys qty 3 of product y and so on.
All I need to do now is do something to also output the total number of products. ie as per example above, 1+1+3+2+3+4+2+1 to get 17.
Can I do a count of the count or do I do some sort of sum of the count results?
I've tried everything I'm capable of as a newbie, and I'm not having any progress.
I having trouble trying to figure out how i can get totals in a report, the report picks the information up from a query i have set up. The report shows various data to do with Grades awarded as part of an audit process (1-4), i want to put a total in the report to count how many 1's, how many 2's etc. i not very experienced with access so can anybody help me with this.:confused:
So i have 2 fields(124816 records) IMKEY, DOCBREAK
IMKEY is like an ID. And docbreak is like a page counter, where some records are empty and some arent(seperated by D's and some C's). im trying to find out 2 things 1> Count how many values are within each group in DOCBREAk. example:
DOCBREAK DOCCOUNT<--trying to figure out D 3 <EMPTYREcord> <EMPTYrec> D 1 D 4 <EMPTYrec> <EMPTYrec> <EMPTYrec> C 1
I tried this query, but it counts everything, i just want to count how many values are within a group(C's and D's Select COUNT(DOCBREAK) from Jan003;
in excel, i could of done it, but since excel has a limit how many rows it can support, i had to do it in ACCESS...
2>in the IMAGEKEY column, since DOCBREAK seperates and makes groups, im trying to as well get the beginning number and the ending number(1st and last number). ex IMAGEKEY Beg End 1 D 1 3 2 3 4 D 4 4 5 D 5 8 6 7 8 9 C 9 9
i did it in excel, but then again, for my personal use, i would like to know how to do it in access heres how i got the 1st number in excel(A=imagekey, and B=Dockbreak) =IF(B1="D",A1,"") end number (C=DOCCOUNT) =IF(C1="","",OFFSET(A1,C1-1,0))
I have 11 sites and I'm trying to missed visits at each site.
Currently I'm counting all non-missed visits at the site, and in the report I'm subtracting that number from Total # of patients at the site. This works fine - but there has to be a solution to the more "direct" method described below.
If I count up the actual missed visits and one site does not have any, the result only shows 10 sites and their totals. If the total count of missed visits = 0, is there a way to have access return that result?
I've tried changing the join relationship, inserting IF ([CountOfDay 30 Missed]) Is Null (or is 0) THEN .....
I know my naming conventions suck - I'm learning as I go, and I'm afraid to go back and change things now. Lesson noted for my next DB......
I have a table which holds roster information for staff. For each day in a 2 week period, there are 3 checkboxes, 'am' 'pm' and 'nt'. I need to perform a count on how many are 'am' 'pm' or 'nt'. For example, if 3 staff members worked on monday week 1 pm, i need it to return '3'. Problem is i am unsure how to perform a count on multiple fields?
first, I do a total query to retreive the frequency of a certain attribute
eg This produces
Customer Depot Order
CustA North 12 orders CustA South 8 orders CustA East 10 orders etc
CustB North 9 CustB West 11 CustB East 10
So now I want to retrieve for each customer, the Depot with the highest order count
ie
CustA North (12) CustB West (11)
I can't find the right structure for the second query to generate the answer, because as soon as I do a group by, I get all Depots again! Or can I do the whole thing with one query.
If there are two similar max counts, ideally, I want to return either one. I suppose I could do a dlookup on the max count to retrieve the associated depot, but this seems sloppy.
Letter Name (blank) Joe c Joe c Joe c Sue d Joe c Sue
How can I know the know letter count without duplications for each unique name? So for Joe I want it to return 3, (= blank + c + d). For Sue it should return 1, only c is unique.
Need help When I try running the query below I get this error.
"Reserved error (-3025); there is no message for this error"
SELECT totalelectricemergencies_1 = (SELECT Count(electricemergencies_1) FROM Phase_1 WHERE electricemergencies_1 ='Always'), totalelectricemergencies_2 = (SELECT Count(electricemergencies_2) FROM Phase_1 WHERE electricemergencies_2 ='Always');
I have a form, with a tabbed interface. On each tab is a subform showing a continuous form with records matching criteria. I'd like for the name of each tab to also include a count of the items in each subform on each tab. Is that possible?
So the name of tab 1, instead of "Opened Cases" would be "Open Cases (X), where X is a count of how many cases are currently open.
I wonder if someone can help me with a count function. I ahve looked at the help files, but I cant understand it. Basiclly I have a number box on a form, I need to add to gether the numbers from each record to form a total.
I am having trouble counting the number of fields that contain a value greater than £0.00 for example I have five fields in a form £5.00 £2.50 £0.00 £3.00 £4.00 I have tried nz =1 >1 my current sting is =count([price]) which results in a count of 5 but I don't want £0.00 counted......
