Search results

Is it possible to use totals from one report on another?????????? If yes how?? Thanks.

Thanks that is sort of what i'm after! At the moment the view i'm getting is: Member of staff, Status, Count. How is possible to have the counts like this: Member of staff, Status, Count(error), Count(Complete). Thanks.

I have only the one table named "Error log" and the query i am trying to run is a having two count fields. I am using two fields from the table 'Member Of Staff' and 'Welcome Pack Status'. I would like to do the following, but where i have stated error count i want the other count to use...

I know how to create macros, how is it possible to print several reports by creating a macro. The macro only lets you select one report at a time, if this is not true can someone correct me?????????? Some brief instructions would be appreciated!

I would like to print more than one report by a click of a button on a form rather than viewing the reports individually. Is this possible? If by a macro how?? [This message has been edited by brin (edited 01-22-2002).]

I have a date field with number of cases next to it. I would like the following date to add up as the days go by. e.g 01/01/2002 =2 cases, then i have i more case 02/01/2002 = 3cases. Can anyone help??

I have several cases which have started on different dates, some have started on the same date how can i get a count of cases on each dates. for e.g 01/01/2002=10 cases?? I keep getting a list o f the same date with a count of one?

I can do a count using "count()" etc and this is fine but alongside this i would like to use total but i keep getting error reports. Can anyone help???

what is the code to view images(jpeg) in vba format??

On a report i have totals which i have created by using sum, count etc. How can i use these totals from the report in a new querie?? The totals i have used are not in the original querie, they are only used on the report. [This message has been edited by brin (edited 12-19-2001).]

I have several reports with totals on the bottom of columns. How can i preview a report summarising these totals on a new report??

How can i set a field so when data is entered it alerts the user that there is already the same data in the database. I know i can do this in the table settings but the prompt only pops up after i have entered all of the other fields on the form, i would like the prompt to appear as soon as you...

I have a drop down list with options "yes" or "no". How is it possible to have a prompt on each selection e.g if selected "no" then a meassage appears go to 'enter date field'

What is the code which i need to write??

How can i create a macro to send a report via e-mail but i don't want to use outlook express instead i would like to use outlook?

I have a yes/no field and would like the user enter yes then have a prompt stating please enter "textalert or next action" or enter no "text alert or next action".

would like the code to return the current date????

why is the setup never the same when i view a report, even though i saved the last page setup??

In a querie i am trying to use a function where the user will have an option to enter two dates i.e from and to. And the results will show anything which lies bewteen the two dates.

How is it possible to remove all tool bars and menu bars(get full view of database)?