Recent content by fredElliotRules

Hi, I have a query using the between clause with dates #01/01/2006# and #01/01/2007#. I have been reading a little on the between clause and it differs from SQL program to SQL program. What are its characteristics in MS Access is it >=#01/01/2006# AND <=#01/01/2007# or >=#01/01/2006# AND...

mysql = "SELECT str((Int([Age] / " & ageGroups & ") * " & ageGroups & ")) & ' - ' & str(9 + (Int([Age] / " & ageGroups & ") * " & ageGroups & ")) AS [AGEGROUPS], Count([AGEGROUPS]) AS Frequency " & _ "FROM Data " & _ "WHERE (((Data.[Date of referal]) Between #" & txtOnOpOne & "# And #" &...

Or as I have just found out wrapping the expression with str() to convert the field to a string and using ADODB.recordset for the rest. Thanks matey.

Hi, I've generated the following SQL statement... SELECT (Int([age]/10)*10) AS MYG, Count([MYG]) AS Frequency FROM Data WHERE ((([Data].[Date of referal]) Between #1/1/2006# And #1/1/2007#) And (([Data].[Age])>10)) GROUP BY (Int([age]/10)*10); the [MYG] field is basically an integer...

Go it it should be .value

Hi, I've got the following code. If Employed.Value = True Then Combo36.SetFocus Combo36.RowSource = "Select * from [employmentBy] where [employmentBy] NOT IN ('[Ignore]','No Employment')" 'Combo36.Text = Combo36.ItemData(0) cmbJobTitle.SetFocus...

Hi, I've got a ADODB.recordset structure storing the results of the following query. mysql = "SELECT (Int([age]/10)*10) AS [Age group], Count([Age Group]) AS Frequency " & _ "FROM Data " & _ "GROUP BY (Int([age]/10)*10);" Now what I want to do is change the name of every record in [Age Group]...

Thanks matey but mysql = "SELECT (Int([age]/10)*10) AS MYG, Count([MYG]) AS Frequency " & _ "FROM Data " & _ "GROUP BY (Int([age]/10)*10);" works great, just got to fgure out how to append values in ADODB.recordset now.

Hi, I have a dataset with an age field which just stored an age. I want to run a query which will calculate the frequency based on all age groups 20-30,30-40. Does anyone have any ideas

Hello, I wish to create a query to produce statistics on two data groups 'A' and 'B'. The query counts the number of people refered in every month (Using GroupBy). I would like to do a frequency count of both 'A' and 'B'. Is this possible using one query. The referal date is a field in the...

HI, Im using the ADODB.Recordset to query a table in my database and it works great. Now I want to query this recordset a second time using the results of the first query. Is this possible using the ADODB object.

Hi, I have generated a standard form for displaying/editing of data and I have also created a form for generating Sql query statements (The form builds a string but does not execute the query). Can I execute a query and use it with that form. So when I generate the the SQL statement and...

Hi, You're right it does say Microsoft Office XP web components is missing. Do I need to download it, then it'll show there and I check it?

Hello, I have developed a MS Access database which uses several functions such as DateDiff and inStr. When I use these function on my machine the database runs fines and the values are calculated. However the database I have developed is not for my computer and when run on this one computer...

Hello, I have developed a MS Access database which uses several functions such as DateDiff and inStr. When I use these function on my machine the database runs fines and the values are calculated. However the database I have developed is not for my computer and when run on this one computer...