Recent content by misuser2k7

Thank you Duane. It worked! I was using the ‘FirstSurveyDate’ textbox which as you pointed out was the reason for the error. I created a new textbox ‘SurveyDate’ and used =Nz([FirstSurveyDate], [SecondSurveyDate]) as its control source. I got a #Type! Error for records with SecondSurveyDate...

Thank you Duane. I used a single textbox (SurveyDate) as you suggested. I entered your code in the control source property of the textbox but I get an #size! error. I don't what it means. I then entered it in the Detail - Format as Me.SurveyDate =Nz([FirstSurveyDate], [SecondSurveyDate])...

I am working with a SQL Server database table which has a couple of Date (datetime, null) columns (‘FirstSurveyDate’ and ‘SecondSurveyDate’) in which some date records in ‘FirstSurveyDate’ column are NULL. This table is linked to Access. I am using a simple query to show all the records from...

MajP your solution worked great! Exactly what I was looking for! Thank you!

I have a table which I am trying to query with multiple criteria. The table which has other columns has 3 that are of interest. These 3 criteria on the 3 columns come from 3 combo boxes on a form. The 3 columns of interest are SurveyName, SurveySubject And SurveyResult and they are in a table...

I have 3 combo boxes on a form. The first combo box’s rowsource is a list of regions such as North, South, Midwest, West …… The second combo box’s rowsource is dependent on the selection of the region in the first combo box, for example, if 'Midwest' is selected in the first combo box, a...

Duane, I will try using TGML tags in my next post. Thank you for your help.

MajP, Sorry for responding late. Your second solution works great. Thank you!

Andy, I am sorry for not formatting the table properly. I'll be honest, I don't know how to use TGML tags. MajP, thank you for your response. The problem with this request is that I am doing this for a co-worker who isn’t very clear about what he is looking for. It took some time to understand...

I need to filter records in a table in a paticular way The table looks like this . . . . . ID TyNum TNum STNum TName TGender TAge 187771 1 0 0 Alex Male 21 187771 1 1 1 Alex Male 21 187771 1 1 2 Alex Male 21 187771 1 1 3 Alex Male 21 187771 2 0 0 Alex Male 21 187771 2 1 1 Alex Male 21 187771 2...

Skip, I tried to give you a 'great post' star but it won't work. I would like you to know I really appreciate your help, thank you!

Duane And Skip, Thank you both! Your queries worked perfectly.

I am trying to build an Access query which counts number of records based which have two fields with no zeros in them. The query result/output is supposed to show records by their IDs and the number of rows that have no zeros in them. The table looks like ....... ID TNum STNum TName TGender...

Andy, Your solution works on the sample that I posted but not on the actual table. I tried the solution with a simple select query and then with the delete query but it didn't work with the actual table. Also, is there a way I can use your solution with only a certain survey type numbers...

Andy and Duane, Thank you for responding to my question. To clarify the issue further ….. Here’s an exract of the ‘Survey_Results’ table with the key numbers …. PartcpntID SurveyNumber SurveyTypeNumber SurveyCaseNumber SurveyInstNumber...