Search results

I was wondering if anyone could throw some light on a problem I'm having. I have a straightforward report - record source is a query. The query has some selection criteria which requires input at run time. This works fine ! (Why change this you ask ? I'm beginning to ask myself the same...

Can someone put me on the right track ? I have a command button on a switchboard , that runs a report from a query. When requested, a Msgbox appears allowing maual entry of a specific 'Request No' that the query uses to pull the relevant data from a table. So far,so good! I wish to change this...

Anyone help please ? I'm still fairly new to ACCESS so forgive me if I'm completely on the wrong track ! I wish to add a control button to a form that will prompt me to enter a date and then calculate and display a date nn (fixed) number of WORKING days in the future. I've seen some...

Anyone help please? I have a monthly summary report(from a query) for the year to date with one page per month and an overall summary page. How can I print the first and last months on the overall summary page showing months reported to date - e.g. Yearly Report 2006 January to May ? Please...

Anyone throw some light on this ? It's probably quite simple but I just can't see it. I have a report showing many detailed records per page. I'm using a straighforward IIF - =IIf([Open]=0 And [Completed]=1,"No","Yes") However if the condition is True I get #ERROR in the report field...

Help again please ! I'm trying to populate a "Quarterly" field ( as in yearly quarters , values 1 through 4 ) in a query. I'm using the following expression :- Qtr: IIf(Month([RequestDate])=1,1,0) Or IIf(Month([RequestDate])=2,1,0) Or IIf(Month([RequestDate])=3,1,0) Or...

Help please , I have a calculated field in a report that works fine (most of the time) :- =(100/(Sum([Sum Of Count])-Sum([Expr1])))*Sum([Completed]) but I get a decimal divide (obviously) if dividing 100 by zero. What is the correct syntax for testing and bypassing this ? Suggestions (...

Can anyone help please ? I have a report with a group footer showing summary information for each month but I wish to remove the page header details showing column headings etc. - is ths possible ? Cheers Steve

Hi - can you help with a simple question from a newbie ? How do I truncate an output field to display the last n digits of a 10 digit field ? Thanks Steve