Hi there,
I'm very new to using MS Access, and am creating a report for a batch of employees - basically a form letter with employee-specific data. In particular, I'd like to make a nice s...
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 ...
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 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 ...
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...
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 a new user of Access 2007 using databases I have developed off of templates, but now need more functionality. I am not familiar with VB or macros, so please treat me as though I'm...
I have been asked to create a project management database in Access. My PC at home is running Access 2007, and one of the Microsoft Online Access 2007 Templates is called 'Tasks.accdb' and i...
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...
i have a report that i would like to sort by selecting a value from a combobox
the combo box needs to be bound to unique records from a table (there are only 5 differet choices)
the repo...
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've built a report in MS Access that uses a query. I want the query to reference an open form for the date range. If I put the code snippet below into the Access Query design view, it says ...
I have an Access 2003 database with a table that lists different companies, employees, job titles and salaries. I have a query that sums the salaries together based on job title. I need to inp...
I have a report COMMUNICATION BY LOCATION that uses the query CommLine, which is based on the dialog box SelComTypeLoc.
The criteria for the query is [Forms]![SelComTypeLoc]![cLoc]
When ...
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 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 ...
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 a report with a Report Footer but I want to not have the Page Header print on that final page because it looks really tacky.
I would need to insert a page break after the final page...
I am attempting to reuse a basic report by dynamically modifying it using user inputted values from a form.
This eliminates the need to create multiple reports that vary only slightly for a s...
I have created a query that brings through a company name (companyname), job title (title), the date (date), the month (date by month) and a rep name (CSR).
To execute the query, the user m...
Hello All,
I need to generate a monthly report that shows billed amounts.
I wrote a crosstab query that will show me customers as rows and invoice dates as columns. I was able to write a...
I have an access report built off a query. I simply want to display the number of records that are returned by the query
something like "=RecordCount" or something like that? I know how to ...
I am working on a database in Access 2007 and have managed to do everything that I've wanted so far without having to make any macros or do any coding... since I've never done either, I'm rat...
Simple form design but detail runs to several pages. Every other page is blank i.e. the continuation of the data on page 1 is on page 3
Cant see where to prevent this, have looked in
File-...
