I failed to process a DLookup Query. Herewith my sample: columns in table : #Sec Code,#QtyOfSum columns in table : Sec Code,QtyOfSum My work is to return...

I have an unbound form that I use to choose parameters for queries. There are four different paramaters that I can enter into the form, and when I click a...

Hello all again I have a table that tracks inspections. I only need to see the most current inspection due though on my report. My date fields are as...

I have a field formatted as text that mostly contains numbers. All numbers between 1 and 10 are carried to one decimal place. I want numbers greater than...

I asked a question here...

Hi, I have a criteria for a field "Date_Actioned": IIf(!!=False,Is Null,Is Not Null) I want a result that: when the option button "optShowAll" is false,...

I hope I can explain my issue properly. I have 2 tables Table 1 - tbl_employees EmpId Name FamilyName ....

I appologize if this is a repost. I wated over an hour but it never appeared. I have an interesting delima. I have a crosstab query that displays...

I'm trying to build an expression that groups individual accounts into quarters based on service date (i.e., any service date where MM is October through...

I have successfully merged 3 queries into one using the following: SELECT Invoice1No, Invoice1Paid FROM qryInvoice1Paid UNION SELECT Invoice2No, Invoice2Paid...

I have a table of Products with fields ID, ProdCode, Description, Available, etc. I need to run a query on this table and exclude all products with 'No' in...

I have 100K rows of data and I want to be able to calculate the median of my field - how do i accomplish this? I dont see median as an option?

I am using Access 2000 This concerns share options. I have a date the option was granted. I am trying to use a query expression that will add 3 years and 7...

hello all i have a table tblwarranty that is related one to many to tblwarrantyparts. each part in the subtable has a dollar value. there is also tables that...

I have a dbase that lists jobs which my department are in the process of completing or have completed. When searching the dabse for a specific job or range...

This is my situation: I have form (note: there is no table for the form), with a list-box “SelectTitle� that lets you select from a table...

I want to create a query (that exports to Excel -I can do the export part), based on the user imput from a form. The are 8 different fields to choose from...

Hey All, Quick question I hope. I have a table filled with customer names and their data. Each record for a customer is nearly identical except for some...

I have a query that is based on a Union Query (joining results from 3 crosstab queries). The columns that I am having problems with are called COSTS, DEP...

Hi, I have a query that has several columns (from a table) that I want to join as a comma deliminted string in a new field. Not all columns contain data. I...