Grouping/Sorting by Date
Wed, 10 Dec 2008 09:26:01 -0800
I have a report which is a collection of dates. I want them grouped and
ordered by date so I setup the grouping and sort order accordingly. However,
it is not working?! It is not respecting the Ascending sort order on the
date field. Would anyone know a reason why this might happen and the
solution.
Q ...
|
How to create a report like...
Wed, 10 Dec 2008 08:49:00 -0800
Hello,
I have a built a query that returns
ProjNum Date1 Date2 Date3 Date4 Date5
and I need to build a report that order the project dates
Oct 1
Proj123 Date3
Proj456 Date5
Dec12
ProjABC Date1
ProjXYZ Date1
and so on
How can I do this? I am lost. Do I need to manipulate the dat ...
|
Subtotals every X number of records
Wed, 10 Dec 2008 08:41:01 -0800
I know how to do subtotals based on the standard groupings based on the
values in a field.
Is there a way to do subtotals every certain number of records in an Access
report (Access 2003 here)? In my current specific case I need subtotals
every 15 records (don't care at all about values in the fields, just ...
|
Count Number of Specific Character in Text Box
Wed, 10 Dec 2008 07:54:01 -0800
Hello, I have read a little about this topic on the forums, but have been
unable to get it to work. I need to count the number of occurences of "#"
within a text box on a report. I was trying to use the Len function, but am
not able to figure out how to make it work.
Thanks ...
|
Display message if certain criteria are met
Wed, 10 Dec 2008 05:56:49 -0800
Hello,
I have a question regarding a database that I am working on. I was
wondering whether or not it was possible to have Access display a predefined
message within a report if there is data entered into text box. It is also
possible that this message could be displayed if an option button is selected.
...
|
Display message if certain criteria are met
Wed, 10 Dec 2008 05:56:44 -0800
Hello,
I have a question regarding a database that I am working on. I was
wondering whether or not it was possible to have Access display a predefined
message within a report if there is data entered into text box. It is also
possible that this message could be displayed if an option button is selected.
...
|
no data on reports
Wed, 10 Dec 2008 05:12:01 -0800
have a form where the user thru option buttons can select a specific report.
based on those options, certain queries are activated. have used the nodata
option on reports to generate a msgbox and cancel = true. the problem is that
after the message box displays, get a run time error of 2501 - open report
e ...
|
|
|
Reports made with VBA
Wed, 10 Dec 2008 04:15:01 -0800
Hi,
How to make reports using VBA code? I must do so that database users do not
need at all to come in to the report construction guide to make the reports.
If some have some example of vba code to make reports will be very
appreciated for your help.
Best regards,
Lilian ...
|
metconv.log
Wed, 10 Dec 2008 02:26:15 -0800
I constantly get an error message when opening Word 2007 saying an error has
occurred in the MetConv.txt file, refer to the MetConv.log file, how can I
avoid this? ...
|
Re: Sum fields with condition
Tue, 09 Dec 2008 15:48:36 -0600
Jason wrote:
>
>Thanks so much for your help. What I ended up with was this string
>Between [Forms]![MonthlyReport].[TxtFrom] And [Forms]![MonthlyReport].[TxtTo]
>
>Before I had not specified that the text box the query needed to be looking
>for was within a form. I was prompted with Enter MonthlyReport.T ...
|
