Search results for query: *

I can't get it to work. The data is coming from a table not a query. Would that be the cause? The columns in the table are City, State, Zip and CS Cachment. Also, it dosen't seem to like the use of the word "combo". Erich

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.

This is the code I wrote in. CLTCODE is the field in the Primary key primary table. It is linked to the secondary table as you say. When I celect the new value in the list box, the value in the primary key field changes but it does not select a new record. The secondary table does follow...

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...

The question would be how do I write the start and end date to the new table and will I get a date for each row of data?

The first query is an ordinary select query

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

Last Question;then I leave you alone. Can a calculated field be used as a Primary Key?

Followup the code code worked with only a small glitch. The middle field is a date field and it is automatically adding /'s. If I can capture the middle charactures, then I can figure a way to dispose of them. (I want =(left([field],2)) & the 4th and 5th characture & (right[field],2))

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".

This is the query that I use to count the number of people at any given age. SELECT DISTINCTROW [Client's Age].AGE, Count(*) AS [Count Of Client's Age] FROM [Client's Age] GROUP BY [Client's Age].AGE;

The formula is int(min([AGE])/10)*10&"-"&((max([AGE])/10)+1)*10. I want to change the groups to 2-12 13-22 23-32 etc.

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.?