I am tring to figure out, in an Acc 1

[quest4]

I am tring to figure out, in an Access2000 query, why TimePeriod is not picking up the GetNumWeeks() variable, which is set to 13. Here is my line of code:
GetNumWeeks() AS TimePeriod,
It now brings up a popup window and wants me to enter it instead of going to the module and getting it. What is wrong here? Thanks you to anyone who helps.

 

[nickjar2]

Is the getNumWeeks declared as public?

Nick

 

[quest4]

It is just a fuction in a module, in fact this is it:
Function GetNumWeeks()
GetNumWeeks = 13
End Function
Ihope the helps. Thanks for the response.

 

[tlbroadbent]

I posted the answer in your other thread. Without the complete query, we could never help you in this thread. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.