Recent content by Terry_C

Thanks - will try both of these later this morning.

I want to enter a value automatically into a form field called "Risk Factor" based on the values entered in two previous fields. The two fields are "Probability" which has values of Low, Medium and High and "Impact" which also has values of Low, Medium and High. The values I want to enter...

Just had my machine rebuilt by our IT dept and using Access 97 I can now no longer insert the MS Date and Time Picker Control v 6.0. I get the "You don't have the license required etc etc message" I can use the control to select dates OK on previously built databases but can't insert any new...

Thanks David and Pat. I'll use two queries as I can't see how to accomplish this easily with a single query with my current knowledge of Access.

David, This is just a test database I created to try out various options (I've just changed Name and Date to Item and Period - same results) In my working database the fields in question are named Create_Date and CELL_ID__A_END_ as posted in original SQL. Thanks Terry

Thanks David I’ve not been able to look at this for a while but still have the same problem. To try and see where I’m going wrong I’ve done the following basic test with the same results. – and still can’t see what’s happening. 1) Created a simple table with two fields “Name” and “Date”...

Thanks david, tried both your suggestions and still the same results. Will persevere on a trial and error basis!

David, Here is SQL - many thanks. SELECT DISTINCTROW [Main Table].CREATE_DATE, [Main Table].CELL_ID__A_END_, [Main Table].REGION, [Main Table].REQUIRED_ACTION, [Main Table].WORK_ORDER_NO, [Main Table].[Category1?], [Main Table].SERVICE_IMPACT, [Main Table].[Monitoring Status] FROM [Main Table]...

I have a query that returns duplicate records based on a selectable threshold (count) from a year’s worth of data. I have modified this to select records from selectable periods (1 week, 1 Month 6 months etc) via a form input to the criteria for date selection. This works except that the query...

I use this method (and believe me I struggle with Access!) but it works for me. If you've already used a Macro to open a new form you can simply close the previous form(s) by: Go into the existing Macro's design view. Select an Action Type "Close" this is the last action the macro will cerry...

I have a table with a date/time field formatted dd/mm/yyyy hh:mm:ss. I need to be able to select from this field via a form and query by using the dd/mm/yyyy data only. If I just put the dd/mm/yyyy criteria in my form "DateSelect" (the query criteria is Like (forms)!(DateSelect)!(text0)it...

Many thanks Anna - that's great Terry

I am trying to run a query similar to the one mentioned by ivanteo earlier. I want to enter one of two fixed values, 14 or 31, into the criteria expression >=date()-"n" where "n" is 14 or 31. However, I want to do this from a form via two buttons which either select 14 days or 31 days worth of...

Fairly new to Access so I guess the answer to this is simple and probably well known but I can't see it - help appreciated please. 1) Report is based on duplicates query which searches for records of similar type (region/location) and displays detail of all other information associated with...