Queries

Help needed with SELECT query
Hi, I need some help with constructing a SELECT query: WONUMBER PARENT AMOUNT HASCHILDREN =========================================== 1234 NULL 10 Y 2345 1234 20 Y 3456 1234 15 ... 3 Jul 2008 12:30

Query Question - I don't know
Is there a way in a query to have let's say three fields and do this: If this field is not null OR if this field is not null OR if this field is not null then do something? Is that possible? Thanks so much!!!! ... 3 Jul 2008 12:30

Problem to write a query result in a text file.
Hello. I have an access database that write several queries result into several text files. It's one query per text file. In a particular one it's happening a strange thing. Access is inserting two records into one column. but it only makes that in ane record and for no particular reason. But the most s... 7 Jul 2008 05:19

Help Designing a Query to Count Classes
Hello: tblClasses ----------- I thought designing this query would be easy, but it's turning out to be harder than I anticipated. Obviously I'm doing something wrong. We need to count the number of classes between 2 dates [Class_Date] field. That's the easy part. Then we have to count the number of class... 3 Jul 2008 12:30

Crosstab Query
I have a crosstab query created and generates the following result set. [ID] [2008 04] [2008 05] 1 5 4 2 4 2 3 3 0 Is there any way that I can crosstab to obtain the following table? [Month] [Total] [2008 04] [12] [2008 05] [6] Any help is very much appr... 3 Jul 2008 10:26

writing syntax
can you write a syntax that says if text in one field is "x" take the date from another filed add 45 days and populate a third field any help would be greatly appreciated ... 3 Jul 2008 15:36

Can anyone translate this SQL statement for me?
Something in this below query is not returning all the values I need, so I need to examine it a bit further to see what it is doing. I don't know IIf statements in SQL too well, so any translation of the below would be very helpful. IIf(IIf([CRMAST]![Points_Owned] And [CRMAST_1]![Points_Owned],[T4: Agg Sale... 2 Jul 2008 18:05

Annual update of Queries
Is there a shortcut to updating the table name that is in all of my Queries? Each year we start with a new table again and I have to go in and manually change every field of every query from the old table name to the new table name. Surely there is an automated way to do this. Anybody know? Thanks. ... 2 Jul 2008 18:05

User Select Top Value Percentage
Is there a way to select a different top value or percentage of the queries results from a form? We have four different types of auditing based upon the representative's team number: - Full Audit (i.e. 100%) - 50% - 25% - 5% Instead having a separate query running to a separate form (which is what I hav... 8 Jul 2008 16:11

Combo box use as a Query... any help
I have a query (qryTrainingByTile) and a form (frmUpcomingTraining). In the form is a combo box (Select Title) that selects the title record from a separate table (tblJobTitles), there is also a button with a macro that open the query when is clicked. I need the query to use the title selected from the combo b... 3 Jul 2008 09:25