Search results

I'm having the exact same issue, but am stuck with A97. Can this solution be converted to A97 and would it work for A97?

Thanks Brian, This works (don't know why I didn't think of it - I'll blame in on "It's Friday") but it doesn't solve the decimal places issue. I still have 13 decimal places showing. I'm not worried about further calc's, this is the end result.

I have a calc'd percentage field in my query. This is a multi user app and the problem is that is can (and does often) happen that the numerator information for my calc gets entered before the denominator data and therefore the calc'd field shows and as an error. I attempted to use a simple...

That is where it is.

I have a simple page number expression and am getting the #name? error. I can't figure out why. This is a very common expression and should work. I have made sure that the control name is not duplicated. I tried to search for the answer but didn't have any luck. Any thoughts?:confused...

I realize this is an old post but I have the same question. Tried to check the Mirosoft site as Rich sugested but had trouble finding it (things change over 4 years I guess). I want to be able to have a "project Data Sheet" which will consist of 2 pages of information. I want to be able to...

Thank you very much for your help. I do now understand why the AutoNumber is the way it is. I was able to concatenate the "E" to the AutoNumber field with a query, and even update the table with a second field with the new lettered number. But that means having to run an update query. I...

Is it not possible because it is a primary key or just because it is an autonumber?

Is it possible to append a letter to the front of an autonumber (which is also my primary key). eg: E568 :rolleyes:

Thanks Rich, I used it too, it worked like a charm. :p

I guess I'm still not getting it.... I created a new table tblEmpProj with the fields ProjectID, EmpID, EmpBID and EmpCID. I joined the ProjectID field in the new table to the same in tblProjectData and joined the EmpID to the same in tblEmployee. I ran a query to test and when I use EmpBID...

:confused: I did try to search an answer for this but I wasn't quite sure just what to search. I'm not even sure what catergory to post under so I'll try here. Please bear with me as I try to explain this... I am relatively new to access and I inherited this DB and been asked to modify it. I...

I have a comments field in a table that is set as MEMO. The form shows all the text in the comments section. The report with this same field is cutting off the comments part way through. The box itself is large enough to hold all the text. Is there a limit to the number of characters the...

I got it to work the way I want by putting this criteria into the query field: >=#1/1/04# Or Is Null But I don't want to have to go in there every year and change it to the current year. Is there a way to say the same thing only using the "current year" as opposed to "2004"? Looking...

I have a report that I need to filter. The report data comes from a query. The date field I need to filter is formated mmm-yy. In my report I want to only show records only from the current year and subsequent years, not previous years. Most of the examples I've seen in my search seem to...

Thank you Pat for your reply... but I was not able to get it to work. I did a little more serching and found this reply from yourself to a similar question and I was able to get it to work. Thanks for everything. Lori

This problem was posted last September. This was the solution offered: I am having the exact same problem and this solution was not able to fix it for me. I have a report listing project grouped by Project Engineer. Some of the Engineers projects continue over 2 or 3 pages and there are...

I had planned on linking the tables. There is existing data in both db's that reference the seperate employee tables with different ID's. If I create a new employee table in the new db how do I maintain the existing employee information in the seperate db's if I change the ID #'s? Is there a...

I have been asked to make some modifications to a couple of DB's we use. One is a DB to track projects with hours (estimates and expended) and the other is used by a different department to track DCF's (or sub projects). Every project could have many DCF's. With as little disruption as...

I did try this. It displays 9900% and enters 0% on the table.