Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 60
Search took 0.01 seconds.
Search: Posts Made By: aattas
Forum: Reports 11-09-2019, 09:39 AM
Replies: 7
Views: 142
Posted By aattas
Re: Chart from crosstab

DBguy, what can I send you. Thanks.

Isladog. I never tried the Dsum. Can I have see example that I can replicate with my data.
The chart that I'm trying is in the footer.

Thanks very much
Forum: Reports 11-08-2019, 08:42 AM
Replies: 7
Views: 142
Posted By aattas
Re: Chart from crosstab

Thankyou for your prompt reply. I appreciate it very much. As a matter of fact, yes I tried to do the sum and division in the query, but because of its is crosstab nature, the report is not seeing it...
Forum: Reports 11-08-2019, 06:42 AM
Replies: 7
Views: 142
Posted By aattas
Chart from crosstab

Experts
I have created a crosstab type of query. and I have created from it a report. wthin the report i created extra unbound fields with sum functions and division function.
next i wanted to...
Forum: Reports 10-28-2019, 03:21 AM
Replies: 4
Views: 149
Posted By aattas
Count but not the repeated ones

Experts,
I think this is a very simple question but nothing works for me.

How can i tell the report not to count repeated numbers?

I did declare to hide the duplicates and still it is...
Forum: Reports 10-12-2019, 06:28 AM
Replies: 3
Views: 133
Posted By aattas
Re: Value from IIF statement

Thanks .I will try
Forum: Reports 10-12-2019, 04:47 AM
Replies: 3
Views: 133
Posted By aattas
Value from IIF statement

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)
...
Forum: Queries 10-09-2019, 09:21 AM
Replies: 6
Views: 123
Posted By aattas
Re: Calculation in a query

Yes. There are fields.

Thanks
Forum: Queries 10-09-2019, 07:01 AM
Replies: 6
Views: 123
Posted By aattas
Re: Calculation in a query

Wow. Thanks for the reply. But can u show me how it is done?. Please
Forum: Queries 10-09-2019, 06:20 AM
Replies: 6
Views: 123
Posted By aattas
Calculation in a query

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 ...
Forum: Reports 09-11-2019, 12:18 PM
Replies: 7
Views: 113
Posted By aattas
Re: Font change after click

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.
Forum: Reports 09-11-2019, 11:02 AM
Replies: 7
Views: 113
Posted By aattas
Font change after click

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...
Forum: Reports 04-12-2019, 11:47 PM
Replies: 5
Views: 135
Posted By aattas
Re: IIfmultiple conditions

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...
Forum: Reports 04-12-2019, 10:41 PM
Replies: 5
Views: 135
Posted By aattas
IIfmultiple conditions

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.
...
Forum: Modules & VBA 03-25-2019, 05:33 AM
Replies: 7
Views: 211
Posted By aattas
Re: How to ignore if its repeated

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,...
Forum: Modules & VBA 03-25-2019, 03:46 AM
Replies: 7
Views: 211
Posted By aattas
Re: How to ignore if its repeated

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...
Forum: Modules & VBA 03-24-2019, 12:37 AM
Replies: 7
Views: 211
Posted By aattas
How to ignore if its repeated

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...
Forum: Reports 03-24-2019, 12:33 AM
Replies: 3
Views: 188
Posted By aattas
Re: Calculation within the report

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.
Forum: Reports 03-17-2019, 03:58 AM
Replies: 3
Views: 188
Posted By aattas
Calculation within the report

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...
Forum: Queries 02-11-2019, 04:30 AM
Replies: 5
Views: 131
Posted By aattas
Re: Numbers displayed instead of text

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 ...
Forum: Queries 02-11-2019, 03:41 AM
Replies: 5
Views: 131
Posted By aattas
Numbers displayed instead of 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 ...
Forum: General 02-11-2019, 03:16 AM
Replies: 8
Views: 159
Posted By aattas
Re: Unrecognized database format message

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.
Forum: General 01-31-2019, 09:59 AM
Replies: 8
Views: 159
Posted By aattas
Re: Unrecognized database format message

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...
Forum: General 01-31-2019, 04:14 AM
Replies: 8
Views: 159
Posted By aattas
Re: Unrecognized database format message

To add the previous problem this what i received in the Msyscompacterror"
Forum: General 01-31-2019, 01:51 AM
Replies: 8
Views: 159
Posted By aattas
Unrecognized database format message

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 ...
Forum: Reports 01-31-2019, 01:46 AM
Replies: 3
Views: 55
Posted By aattas
Re: Repetitive pages in report for each Subform record

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...
Showing results 1 to 25 of 60

 
Forum Jump



All times are GMT -8. The time now is 05:25 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World