Queries
in [Access]
|
New record dosn't work? The new record button at the bottom of some quires or forms dosn't respond when I click on it. What have done wrong? Using Access 2007. ... 19 Jan 2010 11:17
Thanks for your enlighting Thanks John for your help. I will give it a try. Frank John Spencer wrote: Separate field for NotesBy:INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, 14-Jan-10 Separate field for NotesBy: INSERT INTO Catatan ( NO_URTANGT, TGLCATATAN, WKTCATAT, Subject, Notes, NotesBy ) SELECT a.NO_URTANGT, a.TGLCATATAN, ... 18 Jan 2010 23:16
date/time field I have table with Times in them (Date/Time-Short time) I try to run queries for example <12:00 and cannot get proper response 1. Assume short time ok in propertis? 2. How should i type in the criteria section? 12:00 or 12.00 or? Help Thanks Steve ... 18 Jan 2010 17:42
MS ACCESS i have one table with various information that is updated by me every time. i would like to do by query another table that will include four fields: "COMPANY", "TOTAL", "LAST_MONTH", "LAST_WEEK" and collect information for all these field by different criteria. Main table looks like this: | ID | SHIPPIN... 18 Jan 2010 16:34
Combine Two Queries in Different Layouts Hi All, I'm trying to figure out a way to combine 2 queries that are in different layouts. Initially, the 2 tables come from spreadsheets, which I import as they are. Then I create 2 summary queries which result in the example seen below. Table20_Summary Prog Grp 2008 2009 2010 2011 1000 FFA 1... 19 Jan 2010 21:28
Variable as FieldName to populate a combobox OKay - this is probably really reall easy but I cannot for the life of me figure it out... I have 3 tables that I want to cross reference (sort of) - Table 1 - students, contains fields that specify the training they are to attend - so Everyone, Credit Control etc... - these are all Yes/No fields for easy updati... 17 Jan 2010 15:04
Prior 3 Mo Avg Function I am trying to find easier way to calculate prior 3 mo average. Currently, I am doing the manual calculation in Excel after importing from Access. I would like to calculate in Access. In the table, I want to calculate period 12/31/2009 where I need the 3mo average of the prior 3 mo count. I wonder if there... 17 Jan 2010 03:00
How do I left justify a date I have a date with format 'yyyy mmmm'. I would like it left justified. The help says I can use ! but when I type '!yyyy mmmm', Access changes it to '!"yyyy mmmm"'. When I type 'yyyy mmmm!', the "!" is displayed with the date. ... 16 Jan 2010 23:48
Queries with Linked Tables I have created two tables that are imported to an excel spread sheet which I have linked to an Access Database. I have created a field that links both tables and when I create a query for the two joined tables The joined table doesn't return any information. My question centers around what am I missing? What... 18 Jan 2010 16:34 |