Description:
Microsoft Office Access newsgroup.
|
|
|
Missing Information in Query - HELP
|
| |
I am new to access have had a little training but just can't figure out what I'm doing wrong here. My database is built of off basically two tables, one an "Employee Information" table and the other an "Education/Course Table" I then have a thrid table that is a junction table. This third table (Class... more »
|
|
|
Error sending report as pdf attachment
|
| |
I am using Access 2007 and Windows 7. I have a report in print preview and select email...and select pdf format. I then get a message, Before attempting to send an e-mail message from Bookings, resolve the problem identified in the previous maessage, or configure your computer to send and receive e-mail messages.... more »
|
|
|
Parameter query / check box..
|
| |
i have created a small address book in ms access. using parameter query i'm able to get the required address and able to print.. But i have sometimes 10 or more for that i have created a query as In(2,7,9,11) like that to extract the records each and every time.. this is also tedious to get all those hundreds of records by each time... more »
|
|
|
Lookup value in table from value in report query
|
| |
Hi Informed people, I have been reading the forums but can't find a solution to make my problem work. I have a query with the following code SELECT Left([Nat_Reg],2) AS Prov, IIF([Male] = -1, "Males", "Females") AS Gender, Count([Male]) AS Quanity FROM Competitors GROUP BY Left([Nat_Reg],2), IIF([Male] = -1, "Males", "Females")... more »
|
|
|
Seating Chart
|
| |
Hi, I want to make a seating chart report for my student's finals testing. I have an Excel spreadsheet with each student's name, their room number, row number, seat number. I want to make a chart that is a visual aid to where they sit. So I don't jsut want a table listing of names and rows, I want it to come out in the... more »
|
|
|
Multiple Records in One Report
|
| |
Hi all i have a report that combines multiple areas of my database and puts them in one report linked by the Product ID. However on some areas such as Product Maintenance there are more than one record for the same product. When the report is printed it puts these records on separate sheets. Is there any... more »
|
|
|
Print First Character of 30 Byte Field on Report
|
| |
We have an Access 2007 Report that current pulls many fields from a database table. We need to add one additional field to this report, but we only want to print the first byte of this new field. Is this possible? Thanks, Brad
|
|
|
chart axis labels
|
| |
My output report is: WO# Inspection Type Number of Faults 1199 Pre Final 15 1199 Final 23 I need to insert a bar chart,x-axis will be the inspection type (pre final,Final...),y-axis is the number of faults,I did that but the x-axis shows numbers 2 and 3,instead of pre final and final (labels r numbers... more »
|
|
|
Page break within one line of text
|
| |
I have created Invoice reports in Access 2003 that consist of the main report with report headers and footers and page headers and footers and subreports within the body of the report. The problem occurs when printing the report. If the subreport is of the "right" length, a page break occurs on a line of... more »
|
|
|
|
