Search results

Hmmm, I tried that and it just put m/yyyy in as the value in the MyMonthYear field. Btw, I failed to mention that my date is actually in a funky format which is needed of YYYYMMDD See below...it also shows my problem the first 4 are one acct number diff dates shows me 1 for each date. Even...

That won't work because they are dates. So the I have to query a date range to get a month's worth.

I have a table with a year's worth of check information for 45 different bank accounts. I want one report that shows the monthly check volumes per account per month and at the end a summary of all months for each account. Can anyone think of a better way to do this then to create a query and...

Thanks for everyone's quick help!

I'm not exporting for excel. I'm exporting the csv to import into another system.

I resolved it. I added CStr in front of my field which was formatted as a number. I know I have done that while I was messing with this but I guess I had too many issues going on that I must have made an error in the process.

I fixed my problem with the text qualifiers for null fields...now I have just one field that is a number field that I need the text qualifiers around. I feel like because it is a number field it might be causing my problem, but like I said below....I am copying everything from an existing...

Yeah, I have seen that suggestion on here a few times, the thing that doesn't make sense is it works with the other table just fine. I actually re-built it all (identical again) and it is putting the "" in the null fields except now just one of my fields is not picking up the text qualifier...

It is empty...there is nothing there...it is null.

I have two tables identical with all text fields within the same database. One table I export as a csv, delimited with commas separating my fields and quotation text qualifiers. Where the fields are blank there are text qualifiers as well ("" - begining and ending quotations). This is what I...