Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Is it possible to use a query that is based on a function in a mail merge?
I have a word docment that imports data from access. When the query is bases
on a number it wrks fine, but when I use a function in the query, word responds with an error and cannot open the data source. SELECT qselItem_List.*, qselItem_List.ReadyForTranslating FROM qselItem_List WHERE ( ((qselItem_List.SaleID) CurrentAuctionNumber())) ORDER BY qselItem_List.AutoNumber; Here is the function that the query uses. Public Const stCurrentAuctionNumber = 45 Public Static Function CurrentAuctionNumber() As Double Static currAuctionNumber As Double If tempCurrAuctionNumber = 0 Then CurrentAuctionNumber = stCurrentAuctionNumber tempCurrAuctionNumber = stCurrentAuctionNumber Else: CurrentAuctionNumber = tempCurrAuctionNumber End If End Function I would like to use this function, so that I can change the criteria from tim to time by using the setCurrentAuctionNumber Public Static Function SetTempAuctionNumber(dAuctionNumber) tempCurrAuctionNumber = dAuctionNumber End Function Thanks for any help, Shmon |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word Mail-merge to email looses BG Color on Web-Based Mail | Mailmerge | |||
Mail Merge and MS Query | Microsoft Word Help | |||
Mail Merge Query | Mailmerge | |||
mail merge query | Mailmerge | |||
how do I set up a query for my mail merge | Mailmerge |