Search results

Occasionally there will be three (one a trainee) and sometimes the record contains an "&" and sometimes an "and".

The members of this forum (99%) and I (1%) have created a query to look through a table selecting the number of times a particular volunteer has manned the Visitor Centre in a predefined period. Because of the way in which names are entered into the database I have had to search for (say) a...

I amended the sql according to your suggestion to that shown in black below but Access added the extra bits shown in red. It has inroduced an AS and put [] around the quotes. I am rather surprised as I have no idea what the AS does. When I try to run it I get the error message "Circular...

Well that's certainly put me on the right track. My previous knowledge gleaned from computer languages, excel etc does not seem to have given me much insight into access. I am searching around for a good cause to attend in the St neots region of the UK. After this I will redouble my efforts to...

I have a table containing the following fields: Automatic ID RealDate Morning Afternoon I use the name “RealDate” as I originally had other forms of storing the date – now dispensed with. It is just a date. “Morning” and “Afternoon” contain 1 to three names which may be of the form “Joe...

I have an Acer Aspire 5742 laptop running Windows 7 and Office 2010 I have just started using and I have reached the stage where I have started using sql to create and modify queries. When I go to the sql window the text is unbelievably small and almost impossible to read. I tried using the...

I will look into the advice given in post above. Sorry about the confusion in my mind over columns and fields. I grew up extensively using excel and I still think of the table of records as similar to an excel spread sheet. I am trying to seriously improve my very limited knowledge of...

Thanks for the guidance on dates. I understand your concerns but would like to point out that the table is in a transitional stage. The three separate fields containing the fragmented date are the original method for storing the date. The originaa designer of the database was (like me) a real...

I entered the informatio below based on the example given above by jdraw. SELECT [Table Rota].ID (Rem Correct name – not used) , [Table Rota].[Month/Year (Rem Correct name – used) , [Table Rota].Day (Rem Correct name - Compare with Expr4) , [Table Rota].Date (Rem Correct name – used) ...

The format is that of a date, specifically - mmm yyyy - ddd d (the same specifcation as the dates shown below) The main core date in the table is 1. special info about that day (Christmas day, Special Event etc) 2. two volunteers on duty that morning 3. two volunteers on duty that afternoon My...

Thank you very much for this in depth help. It certainly seems to be what i am looking for. I will look into the suggestions and try to fully understand what is happening. Unfortunately I am starting from a very low base.

It's very simple. A few weeks ago I had never used Access and knew absolutely nothing about it. Now I have reached the dizzy height of knowing almost nothing about it. I can construct a simple Table, Form, Query and Report but that is it. I know nothing whatsoever about SQL but I am willing to...

I have a table in a database that contains the following columns: 1. ID (automatically generated) 2. Month/Year (contains month and year such as "Aug 2011") 3. Day (such as "Sunday") 4. Date (such as "28") 5. RealDate (such as "Sun 28 Aug 2012") The first three columns were created by...

Thanks again. What I am realising is how little I know about the whole process you have described. Can anyone suggest a good guide covering this process in resaonable depth but aimed at the novice and any web tutorials/courses that may help me in what appears to be a very steep learning curve...

I am full of remorse for my carelessness in not fully reading the rplies in full. I started reasding the replies on my smart phone, which is very slow and very small and i did not get to then end. I will be more attentive in future. I really do appreciate all your help and, as a newbie, I need...

Thanks for the offer of help. I have attached two files. One is a very simple Access database with the table contsructed as in our volunteer database. The data protection act forbids me posting the actual database which contains much personal data. The other file is a Word file showing the...

The first records in the relevant section of the database are as follows Field 1 = ID Field 2 = Date Field 3 Field 4 Field 5 1 30/12/2005 2 31/12/2005 3 1/1/2006 If I use the DateAdd function I presume...

I have a database with a table which is effectively a calendar containg the people who volunteered that day. Field 1 contains the automatically generated record number and record number 1 relates to 31 Dec 2005. I want field 2 to contain an automatically generated date so that when i start on...

I am very new to access and I am still finding my way around the basics. I have a database that has the automatically generated record number in field 1 and a date in field 2. I would like to generate the value for the date stored in field 2 using the record number stored in field 1. Is this...

I have been using Access 2003, then 2007 and now 2010 for some time but only at a very basic level. I volunteer for a registered charity and I use the database to keep a record of all the volunteers at our nature reserve and to keep an ongoing record of all volunteering in the past, the...