I have a database containing individual fields for people's addresses: Address1, address2, Address3, Town, County, PostCode. Some have 2 lines to their...

Hi All, I'm self-teaching on Access as I develop a client tracking database for my facility. I'm probably going to say this wrong, but here goes. I have a...

I've worked with Access in years past and just getting up to speed on 2007. I've been reading reams of help files and trying various ways for hours to make a...

Sorry if this is a duplicate, I wrote it and think I deleted the message instead of sending it . I wrote an access db for a youth baseball league consisting...

DMin ( expression, domain, ) A column in my query calculates a due date for each record. The report needs to show the nearest/soonest due date for each...

I like to use the same report format but different query for each output. Right now, I have one report for one query. One query is listing SharedAccount, the...

I have user enter information on a form to determine whether my company will fax and/or bill the requestor. So I created group headers on the report to...

Hi All, I'm self-teaching on Access as I develop a client tracking database for my facility. I'm probably going to say this wrong, but here goes. I have a...

Okay, I am working on a student database. Here is how it is set up, specifically related to this problem... 1. StudentContactInfo table/form This includes...

I have an Access Report which I am using to create a text file for upload into a 3rd party application. When Access exports the text file it is creating a...

Hi, I have a report called contactheader. At the header level, I have from tblcontacts, as well as other information. In the details I have all the...

I am using Access 2007. I am trying to set criteria prompts when running a report, which is linked to a query. I am specifically looking for the report to...

I'm putting together a report that is pretty much a sheet of totals based on 2 base tables. The report is broken down by Subdivision and Phase, and has a...

A query delivers somuch data that I can not put all the information on one page. Is it possible to create nice and neat multiple page reports? Thanks for...

Hi, I have the STUDENT report that show Total of students A is 30. I would like to compare it to another total, Total of student B= 35, that is on CLASS...

How can I go about capturing just the first letter of each name so that John Smith would look like JS. The code that I am using is Left(, 1) which works...

Good morning all, I have a form set up for users to select and combine various options. On the command button's OnClick event, I have the selections build a...

Hi. I need to force a new column on a report. how can I do it? thanks

I have several text boxes on a report that have calculated values that would be difficult to express in a single query. Each of these calculated values has...

=DCount("","tblTools"," = AND IsNull") ToolID is a field in my table that is an autonumber (hence, always populated), tblTools is the table in which...