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