Search results

It was all good info. Helped me to remember some basics (data integrity) and taught me the use of SPLIT in public function. Thanks again to EVERYONE :)

I MUST remember to ALWAYS check for source data errors and also do Compact/Repair before I ask for help.

Thanks for all the suggestions. I tried the SPLIT fn but was still getting errors. I did a Compact/Repair but still got errors. I trawled thro' my source tables and eventually found two rows that contained some null fields. I deleted these and hey presto! I can now progress with the next...

Thanks for your reply. No lookups.

Thanks, I'll double check. Just off to bed

Thanks for the reply, Criteria is: .......FROM AV_01 LEFT JOIN AV_01_Hist2 ON AV_01.HorseTo = AV_01_Hist2.[HHorse1]; AV_01.HorseTo works when joined with the source table. AV_01_Hist2.[HHorse1] is the field that I have manipulated with iif and this does not work when joined with the source table.

Thanks for the reply. Fields have valid data - no nulls etc. I think access must change the properties when I perform the iif function.

Hoping someone can shine a light on this please... I have two queries which I join to form another list of data. However, I get the "data type mismatch in criteria expression" error. The joined fields are sourced from two separate tables and are both Short Text in the source tables. I have...

Thanks for the reply. I was perplexed as to why it didn't work so I reverted to my original sql to try and fix it from that angle. Now it seems the original sql works again. I think you were right - something must have got corrupted and I inadvertently fixed it. I'm going to give your method...

Thanks The_Doc_Man, I tried SELECT Nz([B4Q0_Hist_1]![HDate],"#1/1/2001#") AS HDateH but still get the same #Error.

The problem that has arisen as a result of solving the initial problem is as follows: I have a table where the dates are formatted as: Data Type = Date/Time and the General Format is dd/mm/yyyy. My first query changes the date field to be:- HDate: DateValue([RaceDate]). I use this query to feed...

Thanks for the advice everyone. Much appreciated. I found the root of the problem...... I have a table where it appears that the dates are formatted as: Data Type = Date/Time and the General Format is dd/mm/yyyy. Then my first query, which goes on to form the basis of my other queries like...

Thanks for the quick reply. I'll have to look into the US date and format issue.

Hi, Hopefully a quick problem to solve but I've been struggling for past few hours. All I want to do is count how many records (within a set of grouped records) are between 18 months and 6 months old and ALSO count how many records are less than 6 months old eg. My query...

Thank you. That sounds interesting and may be simpler than using Recordset as I would not know where to start with Recordset.

Thank you. Your detailed guidance makes sense. I will try to implement it into code.

Hoping for a little more help please. I have a database which has many fields including: Location, Date, Time, GenRate, SysData, etc. There will be several records having the same Loc/Date/Time and different GenR/SysData etc. (sample data below). I did some research and think I may need to use...

Thanks for the quick answer. Declaring the function As Double worked a trreat.

I've been trying to use some UDF's and have got a small problem. The Function does not return the value I calculate manually. I think it may be something to do with the syntax of the arguments and would welcome help to sort it please. My Query Table is "Today_Time_Track_b" which is made up from...

Hi Colin, Thanks for the tip. I've been testing it out and it looks to be the way forward. Cheers Chris