Search results

Well, I do want them to expect results from entering either choice. It is just one choice will be used 90% of the time. The other will be used, but not as often. I think this would be the simplest way to do it since the users are very limited. Giving them a drop down box would totally...

Running a query that is asking to inout a vaule ( [Enter O-OPen or C-Closed] ) When That question appears, how can I have it default a vaule in there but also give the option to change it? Thanks.

What do you mean? Adding an input mask in the design of the field at the report level?

Ok, that seemed to solve the problem. I ran an update query dividing by 100 and set it to a fixed number with 2 decimal places. Now the problem I am running into, is when I print it on my report, it still doesnt print the last zero if the last cent is a zero. For example 557.60 is coming out...

Tried that. I set up an Input Mask named Currency for that purpose, that doesnt even work. Here is a stripped down version. Here you can see what is happening. Let me know what I should do. Example: The first person on the table Amy Abbott has a ACREDIT of $59,365.00 it should be $593.65

Does any one have any idea on how to force the decimal place 2 spots to the left? I can put the figure I want on a report be dividing by 100 when I pull it onto the report. But, hen there is a zero as the last number, it leaves it off making it look like 557.6 instead of 557.60 I want it to...

No expressions, just a typical append query. I tries something that has seemed to fix whatever was going wrong. The append query actually moves records from a link table. The link table format had the field being imported as currency. I just changed it to text and this seems to solve...

OK, figured out when it happens. It happens after a delete query is ran to clear the contents of the table. The next time the append query is ran, it gives the numeric field overflow error. Any ideas?

I do not know which record exactly as there are several records. When I say it is 12 digits, it is 012345678900 Usually the first 4 digits are leading zeros. I wold want it to format it to look like 0123456789.00 And I have tried changing from Currency, Number, etc., aas well as, Long...

I have tries using every format option. I did a search in the forums, seems other people have had the same problem. This happens intermitantly, that is what I dot understand.

Getting this error while running an append query. Will get it one time and not the next. Why would this be doing this, there are not any feilds that are to small to handle any numeric data. AS a matter of fact, there is only one feild that has a numeric value and it is only 12 digits in size...

OK, have a problem. I have the feild on the link table set to currency, an append query appends the fields to a table, which I have a field that is formatted to currency. But when the feild is appended, it adds 2 zeros to the end of the number, for example: 120000 should be converted to...

Thanks.

Importing data, need to force a decimal point to the left of the right 2 numbers. Should this be done on the link table or in the query? Thanks.

Running an append query, appending to table, get notification that it cant append all records. That is OK, I dont want it to tell me that. Can I turn it off? Thanks.

Get code errors when I try to run it. her they are, pout them in a word doc.

RayH, Can you post 97 versions please? Thanks.

That sounds like a winner, how does that work? What I mean is, how would I set that up?

Is there a way to update several reports at once. What I have is 12 seperate reports, SL1, SL2, SL3, etc..., the detail in all of them are the same with different report footers. It is setup this way because they are used at different times for different reasons. I would like to be able to...

I want to, when a report is closed, to have a macro start. How and where would I do this? Thanks.