Hi

I have a query where the user needs to enter their thier userid. I was wondering if we could use getuserid() in the where filed of a query. I tried this but nothing happens. the query just won't run....no error messages or anything.

Can anyone help?

Anauz

What you want to do should work. The Where clause should look like:

Where YourUserId = GetUserId();

If that didn't help, post the SQL and the function we can probably figure out what the problem is.