Search results

Solved it - I had to have two queries - the first to calculate the expression, and then another querying the first with the criteria.

I am back at this one, because it is not working and I cannot get my head around it. The criteria is on an expression (DueDate: DateAdd("yyyy",1,[RiskAssessmentDate]), but it is returning records where the date calculated is way before or way after the 90 days I am wanting. I have tried...

Aye, that's it! I did say I was being thick :o Thank you

I am wanting a query to return only records that have a date that is between today's date and 90 days in the future, but I am getting the criteria wrong. Currently I have <=Date()+90 - what am I missing?

Having separated everything out field by field, and this is definitley the problem. Bearing in mind that I still have my 'L' plates on with this stuff, what does the above code do? It looks to me that it changes ' for "?

I've just done one at random that has quite a bit of text, and it is 1001 characters including spaces up to the point where it breaks - however, I have a feeling that this is the problem, it is simply too long blowing something out. There are two memo fields in there - I am tempted to take...

Nothing like that in there, it is purely text. I have attached a screenprint of a Word document showing the Debug.Print to show you what I mean about it splitting into paragraphs -- this is a direct copy & paste, and as you can see it just stops mid-word and chucks a couple of line breaks in...

Well, I used Nz throughout, and it still fell over. Interestingly, the text that is produced is broken into two paragraphs at a specific point which is the same point with or without Nz being used on the fields. Is there a maximum number of characters that can be handled in each field or SQL...

And the learning continues! I didn't know that functions like Nz could be used in SQL. Minty, I will try using Nz first, as I can see what it is doing - I must confess that I don't fully understand what your method is doing - maybe that is something to learn for the future though. Thank you...

Ah, that I did not know! So do I have to assign some sort of value if the field is null, or can I have the null values ignored somehow?

Well, it worked just fine for a short while, and it has lobbed its toys about again this morning - I am clearly missing something, which is not overly surprising given that I am pretty much a newbie at this. Here is the line that is throwing up a Syntax Error (3075 - Missing Operator)...

It hasn't done it every time, but I think I have found it - one of the fields can contain dimensions in feet and inches - if those dimensions are written as 13' 3", then that seems to be the source of the failure. 13ft 3in seems to work - I will plod away and come back when I have something...

I am trying to copy data from one record to another via VBA/SQL, however I have ran into a problem. Oddly, it has worked without issue a couple of times, but the vast majority of times I get a Syntax Error 3075, and within the error box I can see the start of the text that is contained within a...

Champion! Thank you :)

I am looking to update a number of fields in a table via VBA - the data values have already been captured, so it is just a case of updating the table with it. I believe that the following will work to update one field: UPDATE RouteRecords Set OperatingRestrictions1 = OpRes1 WHERE...

Thank you both :) I have paused on this particular part at the moment (holiday mode looming!), but will refer back to this when I am at this point.

Is there a way to allow a field to contain dates or to have N/A if there is no date to be entered?

Ah, I thought there would be more to it than that - thank you :)

I have a field that contains a date in dd/mm/yyyy format, and I need to use that to make a text string that is used elsewhere, in the reverse order. For example, today's date is 04/04/2017, so if that date was in the field, I would like my code to turn that into 170404, that will then go on to...

Aaarrgh! I cannot believe I have been so stupid! Thank you :o It now works perfectly. All I have to do is go back and adjust the other groups accordingly. And this helped prove that it is indeed working as it should be - thank you also :)