If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
Calculating totals on a Crosstab Query
Found the problem, but can't fix it
Tracked it down to the name change of my form that has the controls and the query that has the criteria. When I change them it won't work, even though it is all spelled correctly, it won't recognize it.I change it back and it will work. Do you have any idea why the changes won't Take? Thanks Blair "Marshall Barton" wrote in message ... Blair wrote: It actually says The Microsoft Jet database engine does not recognize '[Forms]![FdailyWhelpingReport]![Text6]' as a valid field name or expression. This is the sql of the qry QDailyWhelpingReport That I am using. I guess I should have used this from the start, but I was using the other until I got the results I wanted so I wouldn't have to mess with the criteria until I got it working the way I wanted. Sorry for the incontinence Thanks Blair SELECT [98MatingRecords].[SHED #], [98MatingRecords].[NEST #], [98MatingRecords].[FEMALE #], [98MatingRecords].[Mating Year], [98MatingRecords].[WHELPING DATE], [98MatingRecords].Dead, [98MatingRecords].[1st MATING] FROM 98MatingRecords WHERE ((([98MatingRecords].[Mating Year])=[Forms]![FDailyWhelpingReport]![Text6]) AND (([98MatingRecords].Dead) Like [Forms]![FDailyWhelpingReport]![Option4] Or ([98MatingRecords].Dead)=IsNull([Forms]![FDailyWhelpingReport]![Option4])) AND (([98MatingRecords].[1st MATING]) Is Not Null)); First, make sure that you have UNCHECKed the troublesome Name AutoCorrect feature (Tools menu - Options, General tab). This feature seems to randomly cause strange problems. Of more immediate importance, when you change the name of something, it changes the name of other things with the same name. Then double check the names of everything in the query, especially the name of the form. (I note that you changed the spelling of whelp , but you also seem to have dropped the 2 at the end.) -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|