I have a query where I am trying to count the number of members who have joined during a period of 12 months from a start date sept 01 to following August 31. Instead of getting the total number of members I am getting totals for each member type. I have 12 member categories identified by [TypeID] but each member has a MemberID (Autonumber). I use Sum in the MemberID Field in my query by pressing the Sigma Button. When I run the query I get totals for each TypeID instead where I wanted one final Total. I suppose I need to count the records bearing in mind some numbers have been deleted so numbers jump in the Auto Number field. This is quite asic but I cant get it right. Help appreciated!
First I'd like to say I've learned a great deal from all of your posts. I registered today because I'm having the strangest problem.
Let me tell you that I am in no way a programmer, I don't know any code except some basic html. I was asked to take a 2 day class to learn Access (which was a joke) and then build a database for my employer. I think I've accomplished what they need by using every available book I could get my hands on, forums like this, and the help menus.
Our database is very simple. We only have 3 tables, all of which are related by a field we call our "referrer code".
My problem is this -- we've noticed that some (6)of our records are gone. I have no idea why, or when. We run a roadside assistance company. The database keeps track of members. I can't afford for Access to just drop people. The tables are very small, we only have 1,841 members. There isn't any specialized coding, because like I said, I don't know any. I've mostly used wizards to design.
Does anyone have any idea what, if anything, I should look for. I can send or answer any questions that might help you help me.
I would appreciate anything you have to offer -- even if its just a place to read something that might help.
I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.
I would like to query this table to provide a list of active members between a given range of dates.
For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.
I have registered members and groups in my access database and i want to create a search form that enable me find and edit registered members of groups.
My database is a simple membership database that adds members and by clicking of a button it tells me the memebers birthdays for the month and if i chose to select the send card option then it remembers who has been send the card.
All i want now is a query that will take a member who's memebrship has been expired (since membership is year long only) and move them to another table by looking at the membership dates (like 2004 and 2003).
And may be later on if those members wants to join the membership i can then add them again from that table back to the main table.
i have a table calle "tstaff" and one of the fields in it is named "picture" which hold a link to the picture of the staff membe, the picture is stored on my pc, not in the database.
so in the picture field would be something like this...
Picture c:documents and settingsall usersdocumentsmy picturessample pictureslue hills.jpg
what i am trying to do now is to create a report that displays all the patients data, including the actual picture that the link refers to...
I have created a database containing customer records and i wanted to somehow add a part where an individuals records will automatically be deleted if they are not active for 3 years+
Hello, i am creating a database for a membership of my martial arts academy, so far i can add and search members.
i would like to have a mail merge feature on this, so that i have a list of all the people with a check box next to their name, if the box is ticked their name is added to the mail merge. if its not ticked its not added.
I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document.
The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them in my query results. What I would like to do is add the amounts due so that I only have 1 entry for that family. Additionally, since it is possible that more than 1 person can have the same last name and not be related I would also like to have the query check the address field and if it's the same than add the amounts due. The following is the sql statement for the current query.
SELECT Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone, Members.PaymentDue, Members.Active, Members.MemberDues, Members.FamilyAmount FROM Members INNER JOIN MemberTypes ON Members.MemberTypeID = MemberTypes.MemberTypeID WHERE (((Members.PaymentDue)=Yes) AND ((Members.Active)=Yes)) ORDER BY Members.LastName;
I have list of member in the member table, every month each member makes a payment (monthly fee) as they do they get entered into the fee table how do I find out the members who have not been entered into the fee table (which will show they have not paid )
I have a kids club which do lots of functions for kids, to monitor the members and who is in and out I did a small access data base with details of Start date of the function and end date for each member.
I want to make a daily report showing only the active members in today date only for example:
Jack have swimming every Saturday, Monday and Wednesday Between 14 July 2015 till 14 August 2015 Jill have swimming every Sunday, Tuesday and Thursday Between 14 July 2015 till 14 August 2015
today is 11 August 2015 and I want to report to mention just who is active today only.
I got this far: SELECT DISTINCT count(a.ID) as mCount, year(dimDate.Date) as [Year], month(dimDate.Date) as [Month] FROM admin AS a INNER JOIN dimDate ON (dimDate.Date >= a.sDate AND dimDate.Date <= a.eDate) OR (dimDate.Date >= a.sDate AND dimDate.Date = null) GROUP BY year(dimDate.Date), month(dimDate.Date) ORDER BY year(dimDate.Date), month(dimDate.Date)
I have a kids club which do lots of functions for kids, to monitor the members and who is in and out I did a small access data base with details of Start date of the function and end date for each member.
I want to make a daily report showing only the active members in today date only for example:
Jack have swimming every Saturday, Monday and Wednesday Between 14 July 2015 till 14 August 2015 Jill have swimming every Sunday, Tuesday and Thursday Between 14 July 2015 till 14 August 2015
today is 11 August 2015 and I want to report to mention just who is active today only.
I have a members DB that apart from full details also show payments of yearly subscriptions. I am trying to print a report that shows a list of all the lapsed members. sounds like a simple simple report, BUT...I have a table that includes male and female members on one club number, idealy man and wife, but if for some reason the part company one may not pay the others subs those making the other a lapsed member. is there anyway i can print one part without the other?
E.g. this is haw it prints now
Male Name Paid Female Name Paid J Smith No M Smith Yes
I'm building a customer management database. Part of which is a table to record details of all members of the main customers family or the household compliment.
I'm currently using a DCount to work out how many people on the table are related to my client, to work out the size of the family.....
Could I also then count the members of the household that are under 16 years old by looking at the DoB from the same household members table?
I realise that I'd need to ask access to calculate age at the same time as working out if they're under 16 and then count them if they have the same Customer ID - which might need a little more than this single function!
I have a query to count the number of society members in a particular UK Postcode area. It works well for a single Postcode reference but adding further references to the Query Design View generates an 'or' or 'and' statement, rather than the additional counts that I need.
The SQL code I use for a single reference is : SELECT Count([Mail List].[PostCode]) AS CountofPostCodeH FROM [Mail List] WHERE ((([Mail List].PostCode) Like "BN5 ???"));
How do I amend this code to produce counts for multiple references in one query.
I have a pop up window that maximizes and the need to format a Memo Field to users specification.
Unfortunately the Mini Popup Bar that comes up when you select text is very shy and annoying when it doesn't show up. It's Completely Unreliable.
So I thought I'll make the Controls on the form for Bold,Italic... etc but I can't seem to get the code to work.
My TextField is a Memo and I have changed the TextFormat to RichText, but I cannot use any of the commands like .SelBold or .SelColor etc.. It gives me a Compile Error: Member or Data Member Not found.
I don't understand why? Is there a Add In/Reference that I need to include?
all of a sudden now, when i open my form, its not displaying any of the previous data that i stored in it!! All the data is still in the table, and when i add data it goes into the table!! I checked properties and the record source and everything is ok there, what have i done wrong guys...HELP!!!!
I purchased a copy of Office 2003, on Ebay, for less than half the price it normally sells for. I created databases, which work well on my computer. However, when I copy them over to the office computer from my computer, via Flash memory stick, the program does not run. The message seems to indicate a problem with registration. When I installed Access, it asked me for a registration key, which I did provide. After that it worked-not activation process. Does this mean that you can only use the computer you created the database on to run it, or that I do not have a proper version of Access 2003? I cannot transfer, from my home computer, to the office computer. Is this Microsoft paranoia again? Subsequent uninstalls and reinstalls of the program did not ask for the installation key. What should happen? I would like to resolve this major problem and your help will be greatly appreciated. The program is flaky. Also, Switchboard does not work-must use Option Box.
These questions most user must know about initial installation and copying mdb files to other computers -please reply.
i have a string variable denoted by cui and i need it to take value from table tblPersoaneJuridice from field CodUnicInregistrare. CodUnicInregistrare and NumarInregistrareRegComertului is text.
cant get it running. i got the same query running made in the querybuilder, but somethings change, so i need to adjus it in vba. But it doenswork, and get a type error
DoCmd.RunSQL "INSERT INTO tblAccessLog " _ & "(DateLoggedOut, TimeLoggedOut) VALUES " _ & "(#" & Date & "#,#" & Time & "#) WHERE " _ & "(LogID = '" & LogsID & "');"
Could anyone possibly tell me why this isn't working? Probably something stupid i've done bus still.
When i run it, I am getting the error message "Query input must contain at least one table or query" yet i've told it to use tblAccessLog so i'm just confused.