Search results

I am trying to execute the SQL below (tested in other programs, works fine) but access is giving me the "join expression not supported" error. How can this query be used in MS Access? I have tried breaking some of the joins clauses into separate queries, but I can't get it to work and it is...

I am trying to execute the SQL below (tested in other programs, works fine) but access is giving me the "join expression not supported" error. How can this query be used in MS Access? I have tried breaking some of the joins clauses into separate queries, but I can't get it to work and it is...

Hello, I am attempt to connect to a DB2 table via ODBC. However, each time I do, I get an error stating that the index already exists (two indexes with the same name). Our IT folks are telling me that this is not the case, and additionally, I am able to connect using ODBC in excel, and I am...

Thanks pat. I just figured it out.. it was the export specs. I believe the field list in the specification was out of order, or something similar. A new one fixed it... thanks!

How does this the query in image1 export into image2? Note that the description comes before the amount in the query, which is how it should. It shows up fine when I run the query. When the query is exported, the resulting CSV file has the two switched. Help!

Anyone? Help :/

Pat - Thanks for the help. I figured the problem was something similar to that, but for the life of me I can't figure out where to place the code to make them reset to 0. I have it set when the report header prints, but apparently it needs to be somewhere else. TIA!

In your table, [draw] should be of the type "Number", not "text"

I followed Q132017 to sum the totals for each page on my report. It works perfectly in preview. I have 3 I'm summing, so its slightly different. But for some reason when I print the report the totals come out different from what is previewed. Like the variables aren't resetting, even though...

Worked like a charm! Thanks Pat. First time I've used one of those before :) Have to admit though, that 6 record thing was pretty weird...

I have a function that takes 4 inputs and creates a record in a table (for accounting). I wanted to process a batch of records at once, based on the results in a query. So I made the query to give me the records I wanted to make accounting entries. I then made a second query that has a field...

I have a table where someone types in a number of calls received for each hour. The column headings are like "hour0809, hour0910, etc.." I now want to graph these results, but one of the axes of data (the hour) is stored in the column headings. How can i make a query that will have column A...

Great, I got it to work. Thanks! Any ideas how to make it output say, the first day of the week, instead of the week #?

I have a table with that has a date field and several fields containing numbers. I would like to a query that will sum the numbers by week. ie, have a beginning week date in column 1 and a value (sum) in column 2. I created another table that has beginning, ending dates of the weeks but I...

Anyone? :o

I tried using an alternate method on my query... I changed the field name to say format(field2,"0000000") [the number is 7 numbers, no decimals]. The query runs perfectly, and I can right click export and get exactly what i want. Problem is, when I run my code to transfertext, it gives me...

I have a transfertext line that looks like this: DoCmd.TransferText acExportDelim, "BenSpec", "FilteredQuery", conpath & "Testfile.csv" It transfers fine and how I want it expcept that two of the fields export with two decimals on the end. They are of the type 'number' with 0 decimals. Any...

Hi- I have a bunch of numbers stored in several records in several tables. What I want to do is to pull the ones I want (I have done this via. query), and design them into something like a spread sheet that I can export somehow. I could format it just like I want in a report, but I need to be...

I have a small dot matrix printer I have been trying to use with my program. For many reason, I cannot use a printer driver. I have it working, more or less, but am having one issue. I have the code tied to a button to print all the text, but when I hit the button it does nothing. If you hit...

I have a set of code in a form that I really need to move into a function to use in other places as well. It works perfectly in the form, but when i put it into a module i get the error "you cancelled the previous operation". What it does is calculate interest based on an interest rate that...