Search results

gents, I have a report that has an IIf statement (unbound field) as follows: =IIf([First of Codecat]=2,[AccessTotalsFORWARDTO]*1) =IIf([First of Codecat]=3,[AccessTotalsFORWARDTO]*2) =IIf([First of Codecat]=0,[AccessTotalsFORWARDTO]*0) the result came out perfectly, but when i want to...

Yes. There are fields. Thanks

Wow. Thanks for the reply. But can u show me how it is done?. Please

Hello. I have a case of calculation of addition and division, I need to show the result in a report as follows: Cat1=3 Cat2=4 Cat3=5 Total of Insp: 20 The calculation should do the following: Cat1 +Cat2 +Cat3 / Total of Insp. Should I do this in a query or VBA? Thanks

Gentlemen, Thanks for the suggestions, but i tried a field but it would not change the color. I saw some using VBA to change color, but i dont understand how to do it.

Experts, need help I have a report that has long list of items.one of the field is a link to the main form. the request from my user if the color of the font could change after i click the selected item, This is similar to Google when you have chosen something the font color change as...

Experts, I have solved my problem, With this =IIf([First of Codecat]=2,[AccessTotalsmuamaladate_By_Month]*1,IIf([First of Codecat]=1,[AccessTotalsmuamaladate_By_Month]*0.25,IIf([First of Codecat]=3,[AccessTotalsmuamaladate_By_Month]*2)))

Experts, need help here. I tried to do a multilple IIF, but the results always come out on the first one, how can i tie the conditions and each should act accordingly. Here is the code. =IIf([First of Codecat]=1,[AccessTotalsmuamaladate_By_Month]*0.25,[calculate]), IIf([First of...

Hi again, Can i ask if you could be more specific, you mean one query with one field? If so, i cant do that, because my report depends on the other fields for an attachment. If not, please explain how to do it? Muchas Gracias

Hi easytee, Thanks for the response , i really appreciate it. The distinct works if the fields are all similar (duplicated). But i have cases where the email and address are the same, but when it comes to findings, each is different. So the distinct cannot eliminate any one of...

Gents, Hi, I have the following code: Dim rs As Recordset Set rs = CurrentDb.OpenRecordset(MySQL) If rs.RecordCount > 0 Then rs.MoveFirst Do Until rs.EOF If IsNull(rs!Email) Then rs.MoveNext My problem that sometimes the record of the Email is repeated on the second line, the system seemed...

Gents, My apology for the delay, i was on leave. I tried the footer and it worked for the total, so i did with the grouping sum, and i got what i need. Thankyou very much for helping.

Gents, I have a report that shows (attached) the different of results. I want to know how access report can calculate the results as follows: Total of (1) = Total of (2) = Total of (3) = Total of (null) =

gentlemen, Thankyou for your reply. Isladogs, you are right , thanks for pointing out. I took a note. Gasman, thanks for the reply. I think i found my problem, you guys are my inspiration. The problem was in the Bound Column, it was 1 and when i changed to 2, all text...

Experts, 1- I have a table that has 4 columns 2- I used a field in a form to locate the second column and insert into the filed. 3- The i created a unbound field to display the third column as Description. 4- the unbound displayed properly as per the table (3rd Column). 5- when i...

Sorry for the delay, I decided to reinstall the office, it works fine so far. I have a feeling that my access somewhat corrupted. will update from time to time. Thanks to all very much.

Gentlemen. Thanks for all the responses. To answer the questions for doc man 1.yes. every user has own FE 2-LAN 3-Our language is English but some Arabic characters are used in fields. Question of isladogs 1-,it's 64bit and accdb BTW, it only happens if I change or amend the codes while I'm on...

To add the previous problem this what i received in the Msyscompacterror"

Experts, Im having a shutdown, because everytime my access program goes to the message : " Unrecognized database format......" I had to isolate the database (be) and repair it and copied back. I have no idea where the problem is , anybody knows how to solve this once and for...

Gentlemen, Thankyou for your responses, but actually I found the problem was totally mine. i tried for a fast job copied a report from another file and linked it with the subform. So I guess that system dont see the link. Then I started the report from the base and it went...