Hi, I need some help SELECT count(*) AS ReceiptMethodCount, FROM Correspondence WHERE =!! And =!! GROUP BY

Hi, The DB was not designed efficiently to begin with - I am working with a set of existing tables to provide what the customer's expectation of their reports...

Hi, I imported a report from an existing mdb. This report prints 3-column label. The pageSetup has all its settings for 3 column printing (width, height,...

Hello, In the Page Footer, I have a textbox "txtPage" and its properties sheet control source = "Page " & & " of " & But now, I have to add in language...

I'm trying to filter a report by an input parameter picked up from a combo box on a form without using Access Projects. Does anyone have any tips on how to...

I have a crosstab report that reports activity. The activity is by date on the vertical axis and day of week on the horizontal axis. My problem is that...

I have a crosstab report based on a crosstab query that links "phases" to projects. Each project can have up to 20 phases scheduled. The report works fine if...

Has anyone tried to develop a matrix report from Access. I would like to do something like that but have no idea where to start. What I want to do is have...

I have a report with a subreport. I am printing it via a button and code from a form with a subform. I am trying to print one page with the same information...

I have a report with a sub-report on it. The main report is always a single page. I am printing it with a Docmd using a wherecondition. The...

I have a database that has three reports. I would like to be able to select a report by option button then click a command button and print preview...

Cheers, let's say we have a report based off a query, which would yield: id Part no service performed 10 ASDF CLEAN 10 ASDF REPAIR 13 ...

Could someone help me? I have a query that produces the values for all questions between 01/01/04 and 03/01/04. Question1 has an option value of 2 for...

I have created a bunch of reports in which I set the orderby property with on open event procedure (I have a several options for the sort). For...

I need to generate a report from an Access databse (for banking purposes). Can anyone help/point me in the right direction?

I have a feild called EntryTime that I would like to evaluate on a form. Pusedocode: IIF Entry Time = 12:00:00 AM then display "-" Else Display...

ben 2 sınıflar için problem istiyorum öğretmen dedi

I was looking for examples of conditional formatings for a form or report and can't find what I'm looking for. I need to format empty fields and I tried...

Dear all, I am having error when running the sum e.g. =Sum() , the value of will be 0 or null. I tried: sum(Nz(,0)) and Nz(sum(),0) , but both still got...

I need to format a report to show only the last four digits of a social security number. The field is "SocialSecurityNumber" and the format is xxx-xx-. I...