Recent content by PolarBear

I have (4) fields in Table1 that are associated with identical drop down lists. The query needs to search all for (4) fields for (1) specific result. The data in each field will be unique. So only one of the (4) fields for example would deliver the result "M".I would typically set up a form for...

I have a date field that I need to filter. Individuals are on a committee list that typically has a begin and end date. The end_date field can be populated with a specific end date such as 09/02/2005 or it may be left blank which indicates that it is an open term with no specific end date. Is...

Thanks for the reply. I have an appreciation for normalization. I guess I was searching for a solid answer which you provided. I also make use of SQL server and we have a front end progam that allows us to create multiselect fields. This is very useful when we run queries and search for multiple...

OK - I have seen the other posts where individuals are trying to select multiple items from a list box and have a field populate with the selections. I have not seen a clear explanation defining if this is possible. Essentially, I want to be able to query on the field and search for multiple...

I have a report set up to print data on a preprinted form. The form generates 3 records per page (these are memebrship cards). We then separate the 3 cards print per page. I usually use a printer with full beed ability, so that there is no top or bottom margin. I want to use a printer that...

I am searching for the best method to select a few specific records form a query that can then be used to generate a report based on the few records that were selected from the query. To better explain: I want to run a query based on selected criteria, then from the query results, I want to be...

I have a field that contains multiselect code data. For example, the code field may contain the following 01,05,07 Each 2 number code is has an associated description. If I run a query and link the code field to a table that contains the a Code field and description on each row, is it possible...

I have a table that contains multiple instance records for members: For examle: ID ED_CODE Year 123456 104 1977 123456 104 1972 123456 106 1987 123456 999 1992 Can I create an access query...

Wayne, Thanks for your reply. The code you provided generates an address however, the complete address appears on a single line. I am not getting any carriage returns.When I try to run the Address report based on the address query I am prompted to enter a paramater value for VbCrLf. In addition...

I am trying to create address information of a form and I am using the data from the folowing fields: Address_1 Address_2 City State Zip If there are morre than 2 characters in Address_2 field then I want to carriage return and place this information on the second line of the address. Of...