Queries

Monthly quantities to Weekly
I have a linked query that shows projected quantities on the first day of each month for that month. It also does not display any other dates except the first date such as ReqDate Qty 1/1/2010 3250 2/1/2010 4500 3/1/2010 3875 I need to break these quantities into week... 15 Apr 2010 13:39

crosstab - multiple values required
Would like to create a crosstab query where multiple values are returned for each row/column heading intersection. Have data something similar to this: Group Section Name Title A ONE BOB DIRECTOR A ONE SUE MANAGER A TWO JANE ANALYST B THREE BILL ANALYST B TWO JOE VP C THREE SALLY MANAGER C THREE SUZY DIRECTO... 15 Apr 2010 18:07

Remaining Balance Query
Hello – I have a form that has multiple fields on it…the fields are: BillingAmount1 BillingAmount2 BillingAmount3 And so on…up to 7 Billing Amounts BillingAmountPaid1 BillingAmountPaid2 BillingAmountPaid3 And so on…up to 7 Billing Amount Paid BillingAmountDue1 BillingAmountDue2 BillingAmountDue3... 15 Apr 2010 14:46

I Can't Do This
Hello, Im new to queries and i'm trying to pull off a seemingly tricky one. Somehow I need to 'merge' or 'combine' the two queries below into one: [CODE]SELECT TopicName, Duration FROM tblTopics WHERE (TopicCode IN (@TopicCode1, @TopicCode2)) [/CODE] [CODE]SELECT DateStart... 15 Apr 2010 10:17

How to convert Null values to zero when create an average query
This is my crosstab query Items Worked April 2010 March 2010 Average Reports 2 4 3 Tables 5 5 Files 2 2 ... 15 Apr 2010 10:17

Indexing 2 sides of a relationship
I have a table which to all intent and purposes is: Recieved and Sent. I have a table which has: Rec. Date >> Sent Date (with other information, but i can manage that) I want a query to show : Date >> Recieved >> Sent. But on some days there might not be any entries for Sent or Received. This would be f... 15 Apr 2010 10:17

Total Number of fields in a query
Is there a limit on the number of fields that could be included in the query? While designing a query I get an error message "Too many fields defined" Thanks Leo ... 16 Apr 2010 00:47

Sort on a calculated field
When I run this query, I am presented with a parameter input box asking for tblGrievances.Year (unless I remove it from the ORDER BY clause). How can I sort on the calculated field and the GrievNumber field? Many thanks, Rip SELECT tblGrievances.*, DatePart("yyyy", tblGrievances.Yr) AS Year FROM tblGrieva... 14 Apr 2010 21:11

Parameter Queries in Crosstab Query
I created a parameter query, and then I created a crosstab query based on the first parameter query. I keep getting an error message that says: "The Microsoft Office Access database engine does not recognize '[start date]' as a valid field name or expression." In more detail: I created a query where I have a... 15 Apr 2010 13:39

Why does this query ask for the start date and end date twice?
SELECT Data1.Date, Data1.Shift, Data1.Thickness, Data1.Species, Data1.Plies, Data1.ValueLeft, Data1.ValueRight FROM Data1 WHERE (((Data1.Date)>=[Start Date] And (Data1.Date)<=[Stop Date])); Thanks for any help ... 15 Apr 2010 10:17