In previous versions of access you could save a form and a report and then format as you required.
I cannot work out how to so this in 2007 except to create a new report and copy each secti...
There are 2 questions I want answered.
1) I have a report which has several sub-reports within it. I want each sub-report to begin on a new page.
2) In one of my sub-reports I want to sh...
Hi,
I have a report thats source is set to a pass through query.. I need to make this report a sub of another report. a short while ago I found that this is not possible.. which i find ulti...
generates a quotation, Purchase order and then an invoice number automatically ?
Freeware preferred, else pls recommend a good software.
or microsoft access is a good tool ?
I'm trying to add a carriage return between two fields' data within a report ([field1] + CR + [field2]). I'd swear I've done this before, but I sure can't seem to get it to work now. Anybody...
Is it possible to add a Find Button on an MS Access report and have it find a record in that report? If so, could you tell me how I can do that?
Thanks.
Hi. I use in txbox of the report following expression: =Format([Weighted_DSC],"#,###.00")
If number is <0, Access displays .90
How can I get Access to display 0.90
I have a microsoft access report where I want it to count a specific field. The only thing is the field contains text from A thru G and I need to count how many A's, B's, C's, etc and give m...
I have an access database with a linked table, a query, and a report. The query is designed to pull out one unique record from the linked table based on the information entered by the user. ...
Hi Experts,
I have a budget database which contains my company's annual budget.
I have a cost center report which displays the budget by cost center.
One of the fields in my underlyin...
I have a subreport that totals up values displayed in the details. The sum is displayed in the report footer (the control source is '=Sum([inv_amt])'). If there are no records that meet the ...
Hi Experts,
I've created an pivot table in MS-Excel (2000) but failed to show the complete report as the number of rows exceeds 65K - the limit of Excel.
Is there any way I can create th...
Hi,
I have a form that is used to select two fields that then opens a report and filters for the data as specified in the form.
Form is called frmReportsMenuProf
Drop down boxes are Sel...
What VB code would I use to create 3 groupings in my report(Titled: Report1)
Like the following:
Field/Expression Sort/Order
Name ...
I hope I can explain enough of my problem to get a solutionI dont think it is that hard& but I am an idiot on Access!
My goal is to run a report that will show if the company has hit its ...
Is it possible to suppress a zero value showing in a report, my boss recalls this was possible in earlier versions of access and in 2007 everything is in a different place.
I have a query that returns records where a field (TH6040.SOLN_ID) is not null.
What I need is records where (TH6040.SOLN_ID) is not Null AND is not text characters.
SELECT TH6040.SOLN_ID...
Hi,
I need to line up my report with a horizontal and vertical line.
But I have a control box with a property of able to increase = yes
Which means that the vertical line will be short on ...
I am trying to select the top ten values for every groupheader 0, txtSRSortOrder but am uncertain how to do so. Help would be greatly appreciated.
I am building a report and I am trying to add or summarize two fields from a database. For some reason, the field comes out to be way more then what is expected. How do I fix this? The foll...
Hi,
How can I sort data in access form.
I have few fields in my form.
Customer, facility, address.
I'd like sort data in my form by Customer field in alphabetical order.
If I put dat...
Hi
I am using a query to build a report. In the report detail section I have the following.
1) Text231 which has the following sql statement {=Nz(DAvg("[M2]","[QSalesStock]","[Time] = Forms...
I am having problems with ODBC driver and I am not able to do the following in queries.
I have used this function. With this function I get LITERACY_0708 Or NUMERACY_0708 but I would like to ...
i have a form where a user chooses 2 options from 2 dropdown boxes and then clicks a button that takes them to a report. i have been trying to use textboxes on the report to say what the user ...
I'm trying to allow users to enter data in text fields or combo boxes and print a report based on these values. The problem is sometimes the report prints with the data and sometimes it doesn...
