Queries
in [Access]
|
Concatenate Text Fields to Date Field I have three (3) columns in a table which represent the month, day, and year. The values in these columns are 04 (month) 21 (day) 2010 (year). I want to insert these thre values into another table where the field in the record is a Date/Time type. Here's the SQL statement (in part): INSERT INTO ....... SELECT ... 19 May 2010 13:48
Word merged with Access I am using both Word and Access 2003. When I merge a Word Letter with Access, sometimes not all of the queries show up, in the drop down box, to link the letter with. Does anyone have any ideas of why this happens? Is there a way to make all of the queries show up? Are the queries limited to a certain number?... 19 May 2010 17:10
SQL server backend My mdb file is moving tables from mdb backend to ODBC link to SQL server tables, but queries are in the front end. Should I change the queries to stored procedures to increase performance or I can leave the queries in the front end mdb file that the SQL server analyze the queries at server end even I have queries... 19 May 2010 12:42
Can't see existing table in Design view for a QBE Hi Guys, I can't see a table in QBE even when I have the scroll bar as far left as I possibly can. I have joineed another table to the query and I can see the relationship link but am unable to scroll left to view the table. Does anyone know how to fix this?? Many thanks in advance, Cheers, ... 19 May 2010 19:24
Access 2007 Append Query – Issue with automatically inserted b Karl and Marshall, Thanks for the help – here is more info. I can recreate the problem with these steps (takes about 2 minutes, if you want to experiment) Create new Access 2007 database Create Table1 with one field called “Customer Name” Add one record to this table Create Query1 with “Query Design” ... 19 May 2010 14:55
90 days and the first of the month I'm trying to figure out hoe to calculate 90 days from hire and the first of the month Example: HiredDate Insurance activated 1/3/2010 4/1/2010 That is 90 days and the following 1st of the month Exception to the Rule: 1/1/2010 3/1/2010 ... 20 May 2010 12:47
Access 2007 Append Query � Issue with automatically inserted brack Brad wrote: I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a �purchased system� table that has many field names with embedded blanks.) To understand this issue better, here is what I did to recreate the problem. Created a new table with only on... 18 May 2010 17:02
Help with expression builder in a Query to retrieve wanted dates I have 4 columns/fields of dates in a table: Field A, Field B, Field C & Field D. These fields can be either filled with a date or left blank. ABCD are all "Dates". I want to design a query or report to retrieve dates from Field A. The criteria is: Field A must be filled (i.e. there is a date, not a blank)... 19 May 2010 21:36
Help with expression builder in a select Query I am a beginer of Access. I have a database that consists of 4 columns/fields of dates. These dates/fields can be filled or can be blank. I call them A, B, C, D. Now I want to make a query or report to retrieve the date data in the column/field of A. The criteria for this: all the dates in field A must be ... 19 May 2010 11:35
Access 2007 Append Query – Issue with automatically inserted brack I ran into something strange while doing a Make Table Query that was followed by an Append Query (from a “purchased system” table that has many field names with embedded blanks.) To understand this issue better, here is what I did to recreate the problem. Created a new table with only one field named “Cust Na... 18 May 2010 15:54 |