Search results for query: *

I have a form that uses City, State and Zip Code as Combo boxes. They all use the same lookup table. After I enter the city, I want the corresponding Zip Code to be entered in the ZipCode Field.

I have a form that contaians two tables A and B. These tables are presented such that Table is is in justified format and is the primary table. Table B is presented in tabular format as a subform. the tables are liked so no problem there. I want to add a "list box" that displays all...

I have a report based on a crosstab query. The crosstab query in turn is based on a query that allows me to set a start and end date. I want the start and end dates in the header of my report. How do I get it there? Erich

This is the query that I have: TRANSFORM(Count[Client Demographics].CLTCODE AS [THE VALUE] SELECT [Status Code].Status, Count ClientDemographics].CLTCODE AS TOTAL FROM [Status Code] INNER JOIN [Gender Codes]INNER JOIN [Client Demographics]ON [Gender Codes].SEX_M_F=[Client Demographics].Gender)ON...

I have two crosstab queries that I want to place in a single report. The first has Gender for Colunms and race for rows. The second has Gender for column and Diagnosis for rows. I would like one section to under the other. erich

I want to create a calulated field that combines the first three charactures from field "A"then adds the charactures from field "B" and the last for for field "C".

I have a report that groups client ages by 10's. How do I modify in to start art at 2 instead of zero?

I am preparing a report using access that calculates each persons age, counts the number of people at each age and groups them by 10s (0-10 10-20 etc.) How can I change that to 2-12, 12-22 etc.?