Search results

Roster Table I presently have a member table with usual data, containing a field for first join(this is inherited) but the 'users' of the DB have just put in when a members re-registers so consequently some members have first date registration but others show 'present date join' not 'first date...

I have a query based on payment date which I have extracted the Year part as a seperate Field StartYear, but I want to now add EndYear which just adds 1 year to the StartDate. e.g. EndYear = StartYear +1. Anyone kow please I know i's proably simple but I keep getting syntax errors.

Post Code Try AA00\ 0AA 'note the space' - I had same problem and was told postcodes are difficult because they are not all this format but it suited me because I only wanted the Post Code around my area which was nearly allways this format.

Automatic addition of data On a similar line I also have data I would like to add to a table or make a table but rather than have a form in which you have to fill in the data is it possible to update the table via the system date? e.g I have a membership database where the season starts in...

I need to run a query that updates every year for my report, to find a set of records from 01/09 of the year up to 01/11. I want to base my query on the system date so that if the 'year' is the same as the system date then I get the current years records, but if the year has rolled over( and not...

Many Thanks it works!

Reduced my fields as you said however still get a list of members but not total count only count of list of different member Types. I want to count all members irrespective of their type. Sorry to be so stupid but how do I use DCount instead of a query?

Thanks It does work, shame they dont explain that in the example. In fact it shows the module being saved as the same name as the fuction or at least it shows the same name in the control of the text box I am trying to use the function in so I assumed that was the module name. Any chance you'd...

I am trying to use an example to write my first function. Iv'e copied it from an old version of Access/VB (Access 97). Function FirstOfNextMonth(). I create a new module, type this in and assign the results of the calculation = DateSerial(Year(Now), Month(Now) +1,1. End Function. I try to comile...

I tried Count Sorry I checked - it was 'count' I used in the Query however this returns individual records as 'Neileg' says. So how do you use count in a query that has all unique records. Even if I hadn't include the TypeID field most members have different names and different payment dates...

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...

I am making a database and after a small amount of progress I save it and then copy and save with same name but with an extension V1, V2 etc. so that I can keep a working one as backup. Throughout this process I have come across 'Error accessing Network' connection may be lost.....! I have to...

At Last Really does work. I hadn't been able to figure it out and tried all types of code but never seemed to get it quite right , nearly gave up. Thanks.

Many Thanks in anticipation.... Sounds good will try code ASAP!

Same problems I am also trying to use similar data because the membership database I've inherited is a copy of an example which does not return the data I want. Ive struggled to find a way of getting records for members for current season because my season starts Sept 1st each year and runs for...

I want to run a help form via a button on different forms in my database so that a user can select simple help. I have a table of :- FormID, FormDescription, Helptext. I think a Case statement might be suitable but Where and How do I go about this. I have an unbound option group with toggle...

My Fault On looking for the SQL and checking the tables etc I can see that whoever was entering payments details for the memberships has several dates wrong. Some are in the future and the payments for 2006 are for the middle of Setember 2006! So... it seems I have to get the data corrected...

Input mask in Parameter Query How can I force the parameter query box to show the same input mask as the expected result e.g. AA00\ 0AA so that the user will type in the correct format to search for. I've already entered the format in the underlying table, Query etc.

Sorry Bob -don't work I have now managed to try your code but I can see now why the code is repeated I get two parameter query boxes asking for 2 dates - I didnt want to do this, I only wanted 1 box -if I had to do it this way, and anyway by typing in 2 year dates i.e. 2004 then next box 2005 I...

Thanks Bob Great-- sounds like I could use this -it's a start many thanks