Search results for query: *

Thank you! I never would have guessed it was that simple.

I would like to use a formula that will count the number of cells (within a range) that have text. For example, cell B2 = "Pineapple", cell B3 = "Word", cell B4 = null. I would like the resulting count to be 2. This is what I tried: =COUNT(IF(LEN(B2:B19) > 0, 1, 0)) But the result is 0...

Thanks for the reply. My SQL query, as is, can determine whether the value is null or not. It just doesn't sum up all the null values for each "gcNo". I want to be able to determine the sums of "yes_memberName" for each individual "gcNo", not each individual "yes_memberName" like my query is...

I'm having problems with the following query: SELECT gcNo, yes_memberName, SUM(IIf(yes_memberName <> null,1,0)) as total_yes FROM ballotReportData Group by gcNo, yes_memberName; I want to display the total amount of yes_memberNames that aren't null for each gcNo. For example, I want the...

It is grouping on the dept field. Here is an example of the report that is being produced: name1 dept1 target1 name2 target2 name3 target3 name4 dept2 target4 name4 dept1 target4 In the above example, dept1 should be displayed once in the first 3 rows, but is only displayed in the...

Hello, I created an report in access which uses the following query as the Record Source: SELECT candidate.*, sys_gcdepts.name_e AS dept, enrolment.target FROM sys_gcdepts INNER JOIN (candidate INNER JOIN enrolment ON candidate.file_no=enrolment.file_no) ON...

Hi, thanks for the tip. I'm tried using the format number property but it didn't work. I made a mistake in my previous post. The cell is not formatted as a date, but rather its Category is set to Date in the Format Cells option. Now I need a way to open a form which contains a calendar whenever...

Is there a way to call a specific procedure when a cell formatted as date is clicked?

The XP OS and the MS Access software on that specific machine is French. So when the boolean variable was set to "False" or "True", the system was dishing out "Faux" and "Vrai". I changed the boolean variable to a string and set the variable to "False" or "True" depending on the users choice...

Nevermind, I figured it out.

I developed an Access DB which was running fine on Win 98/2K. Now one of our employees had Win XP installed and she is getting the a 3421 data conversion type error. I don't know why it won't work on Win XP. Here's some more info to help anyone who can resolve this issue: - Using the...

I am having problems making the following query work the way I intend it to work: SELECT serie_no AS sn, STR((SELECT COUNT(standard_id) FROM standard WHERE is_pdf=True AND is_current=True AND serie_no = sn))+'/'+STR((SELECT COUNT(standard_id) FROM standard WHERE is_current=True AND serie_no =...

I disabled the fields because I don't trust my users with that much data. They could easily uncheck a checkbox or change a comboxes value by erroneously clicking somewhere on the screen. I'm surprised you've never seen this method of safeguarding data before. It's very common in ASP and ASP.NET...

I am using a continuous form to display data like a datagrid would. All of the text boxes and checkboxes are disable when the form opens. At the end of each row, I have an "Edit" button. I want this button to enable the textboxes and checkboxes on its relative row. However, when I click the...

Thanks PVH! I forgot to add the space in the arrays' delimiter. That fixed it.

I created a function which will go through every cell in column B to replace "bad" strings with "good" strings. Below is what I have come up with. My problem is that the Replace and InStr functions do not seem to work. My variable strPos is always 0. Replace never replaces the string even when...

I don't completely understand. My query works fine when I take out the clause: AND candidate_course.file_no = '77777' But as soon as that clause is in there, it's not updateable anymore. I think it's because it's a many-to-many query (I want many results from many tables). Is there a...

Hi, I have a Recorset in Access which uses the following query: SELECT course.course_name, candidate_course.status, candidate_course.year, candidate_course.quarter, candidate_course.file_no FROM course LEFT JOIN candidate_course ON (course.course_id =...

That was the problem! Thanks!

My form uses the SQL statement below to populate itsfields: SELECT course.course_name, candidate_course.status, candidate_course.year, candidate_course.quarter, candidate_course.file_no FROM course LEFT JOIN candidate_course ON (course.course_id = candidate_course.course_id...