I have a 90 day period of time that I need quarter hour sales data for. The problem is that if there are no sales, I don't get a 0 value the table just skips...

hi, i created a query (qry1) in access, and saved it. then i used it within another saved query (qry2) to link it to the table. do i need to run qry1 to...

Hello All, I am using a crostab query to produce data similar to the following table. What I would like to do is have the results display differently. The...

Table x has two field: customerid, customer_account_type, customer_account_type’s values = 0,1,2,3,4, one customerid may Different customer_account_type,...

I have a query from tblEmployeeSupervisorJctn. In this table there are 4 fields: chrSupervisorID, chrEmployeeUserID, dtmBeginDate, and dtmEndDate. This...

This one is has been a real "bear" for me. We have a database that tracks overtime for employees. Employees are assigned to one of a dozen or so...

I found several topics regarding in the forum however the problem still continues... In a table I have 2 date fields: From_Date, To_Date. In some rows...

Hi, I have a table with many numbers in a TPID field, I only want to show those records with a TPID other than 2 or 35. I have tried:- Not 2 or 35 Not 35...

hello when i open my query in excel my hyperlink in access will be as a text in execl some thing like this : BFD-1516-126-0010-0001-02#E:\D.C.C\Engineering...

Can I make the following less complicated? PTPKWtlb: IIf( Is Not Null,*,IIf( Is Not Null,*0.002204622622)) Thanks! -- www.Marzetti.com

Running a query for 6 mos of data and can't remember the expression to aggregate volume by week, as in: Week Ending Volume June 1, 08 ...

I am creating a database containing sales information, and the company has a warranty policy that expires 90 after the payment date. I have a field...

I have the following query (stripped down to highlight the error): SELECT Volunteers.VolunteerID, Volunteers.CommitHours, Int(CSng(Sum(-)*24)) & ":" &...

I have a table that I need to create a new field in and then generate the values of this new field based upon an if statement. I can do with a make table...

Hello, I am facing the following problem....I am an access newbie: I have to make a form which has the following controls - DayHours, NightHours,...

I create a query base on a crosstab query. The crosstab query has pivot clause like following: PIVOT tblMytable. In ("A", "B", "C", "D"); It generates...

I am trying to create a query that will check the current clocked in or out status of employees and return a variable of out or in. The employees may punch...

Using Office 2003 and Windows XP I need a query as in something like the following: SELECT DISTINCT Field1, Field2, Field3, Date FROM Table1 WHERE Date =...

I am creating a query and have a field that contains some null (blank) values. I need a criteria code to populate the null/blank values with a value...

I just realized that I can translate crosstab query to Sum(iif(true, 1,0)) function. Please let me know if I am wrong. If it does, are there any benefits to...