Search results for query: *

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

I have a table in which records are identified by 4 different numbers. The table tabulates the results of marketing department’s focus group surveys. The 4 different identifier numbers are the (1) Participant’s unique ID; (2) Survey type number; (3) Survey Case Number and (4) Survey Instance...

Lameid and Meagain, thank you for your suggestions. My main issue is with how the users close the Access database. Append query in the Autoexec works perfectly as there is pretty much only one way of opening the accdb file. I have exit command buttons on all the forms and have disabled the...

I am working on a way to track users who log in and out of 6 Access databases (front end) in different locations (network drives) into a table in an exclusive database with details (fields) such as ConnectionID; Username; User Computer name; database name; date/time logged in; date/time logged...

Thanks for your input, Laurie and sorry for the late response. I managed to find a solution for the issue. I added the following two lines to the subroutine stated in my original post: Forms(stDocName)![InteractNumber] = 1 Forms(stDocName)![ScheduledDate] = Me![ActualDate] + 30 Now the...

This is a follow up issue to the ones I posted in the ‘Forms’ and ‘Tables & Relationships’ forums. The users of the summary report wish to enter data related to each customer interaction by clicking on the scheduled date in the summary report. This works fine if they are clicking on a date in...