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...

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!

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...

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...

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...

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...

I have a fairly major problem: I am trying to create a report that does some fairly complex calculations on a large quantity of records. The calculations must be done in VB due to their complexity. At the end of the calculations, I would like the report to supress the ones that come up at...

I am building a combination of a search that outputs a chart, based on criteria selected. i have the form built properly, it returns a fully functional SQL statement into a textbox on the form (was going to set it invisible). I can put this SQL statement into the row source of the chart and it...

help! troubleshoot this SQL statement SELECT tblYearMonths.YearMonth, [Client Data].[Client Number] FROM [Client Data], tblYearMonths WHERE ((([Client Data].[Beginning Date])<[dateapplicable]) AND ((tblYearMonths.DateApplicable)<Date()) AND Not In (SELECT Format([due date],"yyyymm") AS...

I have a table full of monthly returns for a variety of clients. Each return is due on the 20th of every month. How can i construct a query that will return every month in the last 2 years where there is NOT a return listed in the table?

I have a rather complicated database that processes incoming tax bills. All the data submitted is entered into a form, and I used some complex calculations to tell if there is a difference between what they entered and what it should be. Now I'm trying to generate a report based on some of...

I am trying to make a form that will take a number typed into a text box, and calculate the applicable taxes. The rate changes every year, and the information is stored in a table (beginning date, end date, int rate for that year). It would involve for say 3/21/02, calculating 365 - that date...