Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Partition" in a query

Status
Not open for further replies.

JoanieB

Programmer
Apr 17, 2001
57
US
In a query a field is defined as
Range: Partition([age],90,359,359)

{"Age" being a field in the table selected}

I am getting an error: "Compile error in query expression:
'Partition([age],90,359,359)'"

I didn't write this one and can't figure out why it's doing this. "Help" is NO help, either. I am using Access 97.
Thanks in advance for your time.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top