I am creating a table through query builder.Here the table name contains blank space It is showing syntax error eg:- create table Tiny tots(no text(30),name text(30)) Here Tiny tots contains blank space
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US. click here to Talk to a Technician (only for users in the US for now) and get all the help you need. Goodluck!
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
To parse a Text field that contains two words separated by a comma, follow
Open any existing database.
Create a table with the following structure:
Table: Parse2Words ------------------ Field Name: Empl Data Type: Text
View the Parse2Words table in Datasheet view and type the following
three records in the Empl field:
Create the following query based on the Parse2Words table:
Query: QueryTest ------------------------------------------------------------------ Field: FirstName: Right$([Empl],Len([Empl])- InStr(1,[Empl],",")-1) Show: True Field: LastName: Left$([Empl],InStr(1,[Empl],",")-1) Show: True
NOTE: You can modify the QueryTest query to account for spaces between
the two parts in the Empl field. For example, if the text in the Empl
field is "Smith,John" without spaces, remove the -1 from the FirstName
Run the query. Note that the QueryTest query separates the text in the Empl field into the two fields below:
FirstName LastName -------------------- John Smith Laura Callahan Andrew Fuller
open your table in query, follow steps to do this...
1. open new query in access
2. locate the table
3. once table selected, select field name in selected table you only want to include in query
3. once finished selecting the field save the query
4. you can now view selected field in your table and print as well
5. you can edit the query anytime if you want to add or remove field
6. query will not affect your table since this is only query.
MySQL offers Check Table syntax that checks a table or tables for errors. It works for several storage engines like MyISAM, InnoDB, & Archive. If you run this syntax then you can the cause of problem & reported tables.
If Check Table finds errors then you can repair reported tables by Repair MySQL Table syntax.
Are you familiar with "Linking" tables in Access?
In Access: File --> Get External Data --> Link Tables.
This will bring up a dialog box which allows you to browse to your SQL server and select the table you want.