Recent content by proben930

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