Search results

Hi I have the following code which exports excel files form a query to a folder on C:\. (with a lot of assistance from the forum!) Private Sub cmdExpoirtMissingDataFiles_Click() Dim rs As Recordset Dim CreationMoment As String: CreationMoment = " Created on " & Format(Date, "ddmmyy") & " at "...

Thank you. I am sorry if I messed this up. This level of coding is beyond my capabilities, but I am really pleased it is now working, You're brilliant!

Hope this file size is Ok

Ok. I have 6 countries in the raw data file. Each country has 1 record where the field is blank for each country. The rule is set to true for this field for each country, but the function does not find them.

Sorry, obviously that was only a sample of the data. There are actually 124 country codes with rules applicable to each of these. When I turn the rule on/off it works for all fields except the second one.

Sorry arnelgp. I have been doing some testing and one thing is puzzling. The function does not recognise missing data in the second column., "Survey Methodology (Legacy Anonymous / Linked Data)". It works for all other columns just not this one.

Sorry, my mistake. There were actually a few anomalies in my tables which I have now fixed. The function now works brilliantly. Once again, thanks for your assistance and patience! Cheers

Thanks again for this. I have imported into my project but when the run the function I get an error "Item not found in this collection" at the line varValue = .Fields(fldName).Value

Sorry. Just assume that across 250,000 records there could be blanks in any field in any record

Thanks again Hopefully, the attached will clarify! The point with this is, any company may or may not be required to complete a particular field in the survey. tblDataRules is designed (rightly or wrongly) to look at this.

Thanks

Wow. You asked for a copy of the table. I assumed you wanted to see the table structure not the data, assuming that the real data would have Null records.

Thanks for the response. Attached is a sample table of the raw data.

Perfect! Thank you very much, greatly appreciated.

Thanks arenlgp. Where would I place this in the select statement? I tried SELECT [qryCountriesWithMissingData].[Member Firm], Format( [qryCountriesWithMissingData].[CountryCode],"#"), [qryCountriesWithMissingData].[No of Records] FROM qryCountriesWithMissingData ORDER BY [Member Firm]; This...

Hi All This is a bit messy! I have a table with 57 fields which denote responses to a survey. There are 135 companies that provide the data, each with a number of staff who respond culminating in a table with over 250,000 records. Not every company has to supply data for all of the fields...

Thanks for your response. I am not sure I understand what you are saying though. What I am trying to do is something like Format (CountryCode, "#,##0") but I am trouble with the syntax within the select statement

Hi Could someone please show me the correct syntax to format the field [CountryCode] in the following select statement to zero decimal places? SELECT [qryCountriesWithMissingData].[Member Firm], [qryCountriesWithMissingData].[CountryCode], [qryCountriesWithMissingData].[No of Records] FROM...

Thanks. Got it

Thanks for your response Gasman I do actually have a table that identifies the data completion requirements of each country. I am not sure what you mean "link to your sql to only pull in those that cannot."