I'm writing a report in Access 2003. I have a field [esstatuste] that will contain one of three options: supervised, unsupervised or null. I'm trying to create a text box that will show eith...
What I have is a report that works off off a Query. I have something called a branch in the query and I break them into differnet sections on the reports. What I need to do is count the two ...
One of the fields in an Access 2007 database (which is actually a link to an Excel CSV file, the CSV file being exported from an accounting program) contains text which can be a variable lengt...
Hello All- I have a VBA program that creates a Graph Report in Access. I would like to see some code that will export this Report to a PDF and place it in a folder. Thank you for your help ...
I have a rather odd report. I use queries to collect the data I need into a make table. The report shows multiple stores within multiple counties. One of the criteria that I append repeats ...
I have an MS Access Report with Unbound Text Boxes. I have code that creates SQL Queries, stores them in array arguments (such as arr(1) as seen below) and then assigns the RESULT of that que...
I am attempting to set an Access Report Filter via my Visual basic Code.
I have some variables, arr(0), arr(2) which hold some values that are being compared
When I have the line:
Me.Fi...
Hello i have a table with 2 dates (format d-m-yyyy h:mm:s, example: 3-12-2007 9:05:03)
Is it possible to get the days between those dates?
I have the following table:
date1 ...
My database is a tracking database for a manufacturing facility. I need a query to return data based on dates. For example: when an employee completes a task for a job my database records the ...
hi, i need to compare two tables in ACCESS 2003.
There is a master memebership table1 that i need to compare with membership table2. I need to find the missing members in table2 that are act...
I am trying to figure out the elapsed time for two date/time fields I am keeping track of. The process works well when I do this:
ElapsedTime =[delivered]-[released]
The field format is se...
OK, searched all over for this one, with no luck, hoping some experts can help me. Setup a main form with 2 subforms, where if certain criteria was met one subform shows up, otherwise the oth...
I have an export that works in another database and so I figured i could use it in my current project so I did the copy and paste and then just edited the areas i thought needed changed but no...
I have a Access report that is a "Customer Account Statement"
The report lists Invoice Number and Dates along with the Amounts for invoices that are still outstanding.
At the bottom of t...
I've been creating reports in Access for 6 years, and only now, in Access 2007, I can not do some simple things. I'm trying to create a report in Access 2007 running on XP. Using the report ...
I have a feeling this is not going to be an easy answer. I would like to create a bar graph or pie chart as an MS Access report. The problem is that I am trying to put multiple fields onto o...
Hello,
I am trying to print three receipts in one page in ms access. The report is divided in three and has to be populated with three different records from a table. Can anybody help me wit...
I have a report that is Has a page header, detail section and page footer. None of these have any starnge vba, or calculations just some simple addition and multiplication. There are only 3 re...
I have a label and 6 related fields on a report that do not always have data. When there is no data I can force the label not to show but it still displays a blank line. I have can grow and ...
I have a relatively simple report form with an image control in a group header.
A different picture should appear for each group in the report. When I "Open" the report, the images do not a...
I have a report in Access and I have a field in my table that lists a value. In this case it is a year.
there are about 6000 records but only not all of them have the "year" filled in. I ...
Hi all,
I am attempting to create a dynamic graph utilizing MS Access that involks a crosstab query. See below.
My problem is, check out the legend / order of the graph by dates. It simp...
Hi There, I have a report in an Access Database that prints off onto a pre-formatted page. I am trying to get the area code, mid three numbers, and last three numbers in the correct position....
How do I change the page header on a subreport. I get the page header for the main report. what I am trying to do is have the main report first then the subreport. They have totally differe...
Hello Experts,
Okay, need a little help with this one.
I want to concatenate the firstname and lastname fields on my report to display the following format:
Lastname, Firstname
I co...
