I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...

I want to set multiple parameter queries, and allow the user to enter a parameter for each of them or to select all if they don't want to limit that field. ...

I have a column with the following values SCL (LP Steam Condensate) WF (Fire Water) P (Process Piping) etc... I need to extract only the characters inside...

I am using the following query:- SELECT tblApprovedDefects.RequiredFor, tblApprovedDefects., Sum(IIf((LookupResource())="Business",1,0)) AS...

Hi I am trying to query a table with Yes/No data types in it and keep getting either -1 or 0. Is there a way to change these values back to Yes or No, so...

Hello, I have a table (Main_Data) containing a string field (PID) that has 9 characters, with a sample value being 450895624. I have created a new field...

I am running a query to select all payment and payment reversal records for a corporation based on company name. When I do this I lose seven records because...

This is a query-of-query in ColdFusion and MSAccess This works ok cfquery name="session.getAlpha" dbtype="query" select distinct signerName ...

Hi, I want to be able to generate a report that counts the number of instances that the number 2 appears in a field called BookingStatusID in a table called...

Help. I'm writing a personnel tracking database. At this time, I have two tables. First table is "Main Table". It has everyone's unique barcode from...

Hi all, I need to make an update query but not too sure how to do it. I need to count the number of times an item is listed in table 1 and update a quatity...

Hi I am trying to get a report to run on a query that gets it's records from a table with Yes/No data types in it. When I preview the report or look at the...

Hi All, Does anyone know of a site where I can get a sample of interview Questions for Crystal Report Developer. thanks in advance Ismail -- Message posted...

i have a access2003 qry "qryWages" which looks something like this paymentID Week 6 6a 1 1 £63.89 ...

I want to calc the end time of jobs that I store in a table. We only store the beginning time of each job but the end time would just be the start time of...

hi all, I know not much about sub queries. I need to learn it better. Can anyone recommend any KB Paper, template, book, or anything else where I can learn a...

I am trying to create a list box to give the user the ability to select a specific data point to view actual and budget detail. See my SQL below. This query...

I have field KRITERIUM containing strings for example Biii(aii) or Biii(D1) an so on. I want to select all rows that contains uppercase letters anywhere in...

I have been though most of the thread associated with query append and dateadd to see if I can locate a criteria that will suit my needs. I am working on...

Hi I have in my query 3 check boxes, which I want to make only one available to the user - thus making only one option available at a time. I can achieve this...