Running & Setting Up Queries - Page 1493

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
DATE SERIAL by Akrt48 Hi I have done the dateserial(left(,6,2),Right(,2)) which seems to have worked fine, except it will not let me format the date all it returns is 01-Jan-06...	January 27th, 2006 03:32 PM by Akrt48	5	131
CREATE PROCEDURE by David Berg I'm attempting to write a simple CREATE PROCEDURE statement (in anticipation of more complex ones later), eg.: CREATE PROCEDURE proc1 AS SELECT guild_cd FROM...	January 27th, 2006 03:19 PM by Gary Walter	2	107
Projected Business Days by umm_ism I am currently projecting a date in a query that is 30 days prior to the field using this formula: DateSerial(Year(),Month( ),Day()-30) I would like to...	January 27th, 2006 03:15 PM by Bob Miller	2	114
Access Cross-tab query should allow fields variable in sub-queries by JL Currently in access with a transform query, all subqueries cannot have field name variables. Please Fix. ---------------- This post is a suggestion for...	January 27th, 2006 02:08 PM by [MVP] S.Clark	1	184
acExportDelim +Saving File Name by Stryker22150 I have some reports that I need to be able to save the file name dependent of the value of a field in in the parameter query. ie.. field name has a 3...	January 27th, 2006 02:07 PM by [MVP] S.Clark	1	194
How can I add the XML Values in an Access field by XMLUnsure I would like to query a database and add the values in a string of XML in a particular field. Is there any way to do this using SQL?	January 27th, 2006 02:04 PM by [MVP] S.Clark	1	128
Finding the 70th percentile by Basil Hello, I have a huge amount of data in a table. These are times taken to fly somewhere. I want to group this data by month and year, and for each month I...	January 27th, 2006 01:34 PM by Tom Ellison	4	118
Use count function to ignore duplicate entries and create new vari by Abby sI have a database that records people and donations they make over time. There are two table 1. Donors (with fields: ID, last name, first name) and...	January 27th, 2006 12:37 PM by John Spencer	2	128
Problem with LIKE operator by MGFoster -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'll add my 2 cents.... If the user doesn't enter anything in the parameter prompts then the parameter is a...	January 27th, 2006 12:24 PM by John Spencer	1	104
query unique count for field by flc123 I am trying to count a sorted number field in a query. For each identical number I want the count to increment by one. For example Number Count 183 ... ( 1 2)	January 27th, 2006 10:28 AM by Lancslad	16	272
How do I use access queries to select records which appears 3 time by Aviador380 Hello, I have set up a database to record staff sickness, and I would like to create a query that pulls out records where the staff member has 3 or...	January 27th, 2006 10:23 AM by Dann	2	208
Re-attack by red skelton via AccessMonster.com Hi everyone, I am doing a re-attack on a message I posted her a couple of weeks ago. I'm still trying to make this query work but no luck. I have tried...	January 27th, 2006 09:50 AM by red skelton via AccessMonster.com	3	133
How do I return zero for a query count? by derwwing When using Count in the Total field of a query, if there aren't any records that match the specified criteria, how do I get the query to return a value of 0,...	January 27th, 2006 09:36 AM by Ofer	2	105
Assign File Name Based on Parameter Value by Stryker22150 I have some reports that I need to be able to save the file name dependent of the value of a field in in the parameter query. ie.. field name has a 3...	January 27th, 2006 02:20 AM by Stryker22150	0	102
building a web site by Paul I just got back working on my website. Its taken a long time to finish but I am getting there. I got great web hosting at http://www.domainnamefree.net ...	January 27th, 2006 01:23 AM by Paul	0	125
SUM DATE into months by mccloud I have a query that sums qty sold by item and by class within a date range. I want to create a second query that sums the date by month and year. I've try...	January 27th, 2006 01:18 AM by mccloud	3	106
Query input must contain at least one table or query by robboll I have two queries -- the first is a query that has no tables, but references two control values on a form: Query1 TDATE: SELECT Trim(!!) AS , "NOT USED" AS...	January 27th, 2006 01:14 AM by robboll	3	137
date Field by mccloud I have a date field in a query pulling from our ERP system. I've used a between statement in the past to get the data I need. I now have a need to calculate...	January 27th, 2006 12:50 AM by Rick Brandt	1	109
set criteria for several fields by Pat I would like to select records of dependents born prior to Jan 1 1986. My fields are Dep1, Dep1DofB, Dep2, Dep2DofB, Dep3, Dep3DofB etc. I need...	January 27th, 2006 12:47 AM by Rick Brandt	7	116
update query random number by Kenny G Hello, I need some help on generating a number with an update query. I have run the query and the query runs and will generate a random number each time...	January 26th, 2006 11:36 PM by Vincent Johns	4	108

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