Running & Setting Up Queries - Page 1506

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
new query, new problem by red skelton via AccessMonster.com Hi everyone, I'm having a problem with a query. I have two times, a TimeFinished and a TimeStart. The senerio is that I have a room that could be used...	January 19th, 2006 04:19 PM by red skelton via AccessMonster.com	2	100
how do I print date picture was taken while printing picture by jockco How do you print date picture was taken with the picture?	January 19th, 2006 04:18 PM by Rick B	1	134
how to drop and create a table using sql by Akilah I'm trying to drop and create a table in access 2003, but I keep getting a syntax error. What is the correct sql code to use? Thanks, Akilah	January 19th, 2006 03:40 PM by Brendan Reynolds	1	106
Finding data for the latest date by Mark Olsen Hi again, Ok, new question. I need to find information for the last milestone passed. Now I have a table like this Main table: ID \| Other stuff...	January 19th, 2006 03:24 PM by Allen Browne	1	112
combo boxes by Francis Hello, **********Introduction:********* Have a database to a company, where i store the entities contacts and data in a table Company_Table, that links to...	January 19th, 2006 03:22 PM by Francis	6	110
Parameter Date by jackle I currently use a parameter query (in an Access query grid) that has a pop-up that asks for a date. Is there a way to have it automaticly use today's date if...	January 19th, 2006 01:39 PM by jackle	2	96
Multiple Record Query by Christine Lisi I have a column in my table called Record #. I need to perform queries on a regular basis which include specific Record #'s. So I may need to select over 200... ( 1 2)	January 19th, 2006 01:35 PM by Christine Lisi	13	159
Altering fields in a query by Mark Olsen Hi, I have a question that I really have no idea how to resolve. I am working on a database that I have read-only access to. The problem is is that I...	January 19th, 2006 01:05 PM by Mark Olsen	4	112
How to automate this...? by Bonnie Hello everyone! Using A02 on XP. Not a programmer but lovin' learnin'! I have a little DB that I'm using to import .txt file from our system, replace SSN's...	January 19th, 2006 08:50 AM by SteveS	3	110
Table or Query information by James McDowell I would like to know of a query that will tell me the type of each query within a database, AND what tables/fileds it updates/makes. OR query each table within...	January 19th, 2006 08:49 AM by Mike	4	157
Columns to rows in a query by Mark Y via AccessMonster.com Hello all, I have a query as below: ------------------------------------------------- SELECT SLEEP2.FamID, SLEEP2.ResID, SLEEP2.Salutation, SLEEP2.Add1,...	January 19th, 2006 08:42 AM by Mark Y via AccessMonster.com	2	118
undefined fucntion by shank I have the below function I used yesterday without issue. I'm using it in a query. Today I get an Undefined Function error. I know this function was harvested...	January 19th, 2006 08:33 AM by James Minns	1	94
hard count in top values subquery by scrappydue How do I limit the following query to max 10 scores eliminating the ties on the high side? SELECT tbl_Last20., tbl_Last20.Score_ID,...	January 19th, 2006 06:44 AM by Marshall Barton	8	175
How to return multiple columns from a single column table? by Mota Hello; I have a table having 2 fields:DID,dName.Although DID is a unique field,the table's PK and a Long accending number,but its numbers are not...	January 19th, 2006 04:53 AM by Mota	2	201
How To Write Query by Martin FieldX in some records in TblData contains a value while in other records it is null. How can the query be written which gets the criteria for FieldX...	January 19th, 2006 03:09 AM by Martin	4	124
Exporting Delimited Files by Stryker22150 When exporting a query in delimited format with null values the data is pushed to the left. I need to be able to maintain consistency. I have discovered I can...	January 19th, 2006 12:44 AM by Stryker22150	4	136
split names in into 2 fields in access by Harry1701 I have a name field that has the complete name in it. I need to seperate it into a FirstName and LastName fields. The names are entered with space between...	January 18th, 2006 11:35 PM by Douglas J. Steele	2	103
Can't group on memo error by Todd I have a field on a table that is a memo format field. I am trying to write a query to include this field but get the "Can't group on memo or OLE object. Any...	January 18th, 2006 11:34 PM by Jeff Boyce	1	82
Variable from Exported Excel File by LJG Hi Guys, How can I get a variable from an exported excel report, as I need it to help with the naming of the file? TIA	January 18th, 2006 11:04 PM by Douglas J. Steele	5	102
My text data isn't showing in query - how do I fix this? by writer Help! I can view the text data both in a form and table, but the information doesn't show when I run a query including that field. How do I fix this?	January 18th, 2006 11:03 PM by writer	5	96

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed