Search results

Can someone explain why this is evaluating as having no records when I actually print the strSQL and run it, it produces several records. The problem is with the WHERE Clause, if I change it to this: It works as intended... But I was having a serious issue with using double quotes and such...

Sorry Wayne, After the fact I realized why the double quotes didn't work... it's because I am also trying to add an ampersand WITHIN the strSQL...If you do this, access will post your backslassh with no quotes or double double quotes...neither work. There are a number of ways, I found, to...

Because I wan't a string value with an ampersand, and double quotes around a backslash... it was pretty much impossible. No matter what I tried, it either gave me a backslash without any quotes or a backslash with two sets of double quotes... I even tried using the Replace() function with...

Thanks, That works great, (fyi: it's missing the end if, if you wanna edit...) Thanks again! -Gary PS. Still am curious as to why my code didn't work... if anyone knows...

Tried that.... still post: [temp_TOA_A12].[PATH] & [ITEM].[PARENT] ""\"" AS PATH what's up with the double double quotes?

I have about 59 tables that all start with "TOA_". I want to delete them in one fell swoop. But it's not working... When I run this code (below) nothing happens. The strSQL (when pulled from the watch window and run in a query object) shows 59 tables with names starting with "TOA_"... yet when...

OK so I am trying to create a SQL string where the name of table is a variable. I can do this with no problem... my problem is that I am also trying to create a special field within to make a path... So the path would look something like [Path] & [some_field] & "\" as New_Path... The only...

Yep, all three assertions are true. I have just found that it often makes life easier to pull stuff into a new table vs. working with an aggregated query. Whatever floats your boat.

I guess normalization is god and may very well smite me down, because I just posted a solution to the very same type of issue a few minutes ago in a thread entitled “Updated query with Select statement”. I know for a fact people on this forum are WAY-WAY smarter than I am and usually get me...

I think because you have the link and you are aggregating data (i.e., counts) you can't update the table within the query you made. What you could do is change it into a make table query... then you'd have a table with the counts you wanted in a table and you could apply those to your table...

You might want to try these steps 1) use the unmatched query wizard to find all records in one table that isn't in the other... 2) Create a make table query, using your unmatched query as the basis for it 3) set up a query similar to the one in your jpg to make the appropraite changes to the...

Another thing you can do is create a Data table that you will append to. Everytime you need to append a new set of data, you'll run the import spec (basically replacing the import table) then use that import table to append your data table using an Append Query. Something like...

I was also running into the same problem when pulling extracts from Excel to MS Access and did find that a leading ASCII value 160 was the problem (as previously posted). Seems silly that the Trim function doesn't get rid of all leading and trailing spaces. I don't know why I'd ever want to...

OK I decided to go ahead and revamp all the data and objects to show you guys the issue I had with this data. When you run the code in the module named: Format_Spend_Charts it fills a table named "SAND_CHARTS_FINAL" You will see that the query which is the basis for this (i.e...

Because I am. This is a good suggestion, but there is no error, per se... the value simply isn't coming up the same on both sides... no error is thrown. Hmm... well... I checked the loops... because the query is a cross tab it has a limited amount of records (around 68), so it is easy for me...

The code was there as an example of what I was trying to do... it wasn't there for you to recreate the issue. How could you...really? you don't have the query that I was running nor the data behind it... Many times I have submitted posts to this forum without any code at all and have had the...

Eh rs was supposed to be rsQ... I was trying to make the code relate to my post, so I went in and changed the part that was mesisng up, in my debugging process, to match the example I was talking about... I don't show all the code because it's not relevant and some of the names I actually had...

Yeah, It's kind of a complex concept to write down. I probably didn't explain myself the way i needed to. Basically when I use the code above to update a table from a query... what should happen is the code loops through each record, field by field and places that value into a table. The...

Hmm... I don't think this has to do with linning up... I go line by line. The value which equates to 1845 in the query is the one that equates to 1883 in the code... some of the other values change as well and some remain the same... But because the crosstab query rolls everything up this is a...

OK I feel like I am going nuts here... I have a set of Queries... basically three selects and three crosstabs which pivot on each of the selects... Then I have another query which pulls these three sets of data together, lets just call it qryX. When I run: "Select * from qryX;" I get some...