“Function is not available . . . in query”

Topic

New Reply

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

Replies

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

For some reason I get the following message when trying to run a query with “SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)” as the Field to append to a table:

“Function is not available in expressions in query expression ‘SSN: Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’.”

Any ideas what would cause this?

Thanks,

Ken

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Do you have any VBA in your database? If so, one cause of this sort of issue is a missing reference in VBA. I presume you are assembling just the digits from a field that stores SSNs with dashes in position 4 and 7.

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

Wendell,

Thanks for the followup.  Yes, there is VBA Code.   I have 7 references in the VBA project, and all appear to be there.  For the sake of expediency I added a module in VB to update the field using the ‘Left([Field4],3) & Mid([Field4],5,2) & Right([Field4],4)’ and looping through the recordset. 

Very strange.  FYI I am using Access 2003 SP3.

Thanks again.

Ken

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote

If it were a missing reference you would probably get an error in VBA as well. But those functions should work in a query – I use them on a regular basis to do much the same sort of thing. Seems to be a bit of a mystery.

Reply | Quote