Search results

In your query, if you right click and go to properties you can set the third fields decial places. Hope this helps, Sam

I am trying to make a union query out of two tables in a unix database and keep getting an error message. It says ODBC Call Failed and it continues on with some jiberish. Could someone look at the attached message and see if this error is fixable and how? Any help would be greatly appreciated.

Is it possible to export a subdatasheet with a query into excel? My delima is that I have to reconcile an account and the information is in two different tables...One for one company and one for our information. I need to show which entries match and which don't. Anyway...is this possible? Thanks

Is it possible somehow to add a yes/no box to a linked table through VB or anything?

I still am pondering over this issue and looking for a solution. Here is my problem...I am using a linked table as stated above and I am not able to edit the properties. I am trying to make a form to reconcile some trades. I have all the trades that I need in one table, but I need to add a check...

The only uniqueness we have is to compare the date...price...# of contracts...etc. We kind of have to look at each one and reconcile it with a statement from our investor. It sucks!!!! The programmers are morons and should be fired!!!

I am not sure if we are on the same page. Let me try to explain a little further. Everyday we enter trades into a Linux database and these trades are stored in the open trades table until they are closed months later and they are moved to a closed trades table. I am needing to reconcile these...

I am using an append query to take information from a linked table which I am not able to edit, to a table that I can edit and add one field to. Here is my problem...I would like if everytime I ran the query I would not duplicate the records, but only update the information. I am going to run...

Will give that a try...thanks

I am needing to use code to go through a table on the exit of a form and change all the checkboxes that = -1 to 0. Is there some code I can use for this or is this even the best way to change it? It thought maybe something like i=1 For i = 1 to EOF (I need to reference the column...

Thanks, I will give this a shot. Appreciate the help.

I have 2 issues. 1. I have a report that my boss is wanting and it is very large. I have had to include 3 union queries and many fields. I have tried to trim it down and cut out the unions, but just not possible. The report is extremely slow and that is one problem. The other is I would like...

No it didn't. If I split the union query so that it is just a select query and only use part of the dlookup formula it works fine. Could it possibly be the union query messing things up? is there another way I get data from the previous month?

Well, it's in a report that is populated by a union query. I double checked the names several times and that wasn't the problem. On the report it just says Error#.

I used that formula, but I keep getting an error message. I am pulling this inforamtion out of a union query. The t is a datepart formula and the isyd is a number. Any suggestions?

On this subject, is there away to use multiple criteria in a dlookup? Here is what I have now: =DLookUp("[ISEOH]","[SID'S 2]","([t]=" & [t]-1) What I am doing is looking up the previous months total in Sid's (union query) when the month (t) equals the previous month. I also need it to equal the...

No, but I will make that my next move. Thanks, Sam

Yes, All months are in one field, all dates in another field and there are about 4 summed fields.

I have the data in a union query and then summed in another query. The way I have to structure the report is as such: month Item: 2001 2002 2003 data summed data ... The problem is...

I have a report that needs to show three consecutive years of data. I am using a Dlookup right now to get the previous years, but that is extremely slow. I am using a query to gather the data and have a report off of that. My dlookup is in the report. Any suggestions?