Go Back   Access World Forums > Search Forums

 
Showing results 1 to 5 of 5
Search took 0.02 seconds.
Search: Posts Made By: templeowls
Forum: Queries 06-20-2019, 11:29 AM
Replies: 12
Views: 285
Posted By theDBguy
Re: Can a single query parameter allow multiple entries?

Hi. Unfortunately, it was important to see the parameter part of the SQL statement in case the error is within it. Are you saying the syntax error is in this part of the SQL statement? If not, can...
Forum: Queries 06-20-2019, 10:47 AM
Replies: 12
Views: 285
Posted By June7
Re: Can a single query parameter allow multiple entries?

Neither can we if you don't provide your attempt for analysis.

@The_Doc_Man, as theDBGuy explains in blog, array list for IN() cannot be dynamic in query parameter.

I never use dynamic...
Forum: Queries 06-20-2019, 05:32 AM
Replies: 12
Views: 285
Posted By The_Doc_Man
Re: Can a single query parameter allow multiple entries?

Yes, but if and only if the SQL expects a list. Further, the syntax required might be a problem since Access default behavior on quoted strings is to strip one layer of quotes at each layer that...
Forum: General 06-12-2019, 06:49 AM
Replies: 7
Views: 201
Posted By isladogs
Re: Create a query from two tables that autofills column

Are one or both fields memo (Aka Long Text) datatype?
If so, any of the values more than 255 characters? If not, change to Text datatype so you can do the join.

If that's not possible, we will...
Forum: General 06-11-2019, 09:42 AM
Replies: 7
Views: 201
Posted By theDBguy
Re: Create a query from two tables that autofills column

Hi. Welcome to the forum. I hope you're not trying to store/copy the manager info to the location table. If you're only trying to produce a combined data for a report or a mailing campaign, you can...
Showing results 1 to 5 of 5

 
Forum Jump



All times are GMT -8. The time now is 10:05 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World