I have a query that has one prompt for CSS name driven by a form with an unbound field so that the user can choose the name. The prompt works in that...

I have the following Table: Week End Date WK # 10/17/09 11 10/24/09 10 10/31/09 9 11/7/09 ...

I have a table full of items, below is one example from the table. I am trying to do a query that will display the longest dimension (as L1) for each item. ...

Hi All, I have created a query where I can get a count of a specific person's activity. These people log when they recieve mail and when they have actioned...

I have a very simple question, which I am not able to resolve though. I have created a query, which combines records from two tables. Works nicely. Now I...

I have created a query in my database using several tables. My table has a list of shifts that an employee has done in a day. For each shift completed there...

I have currently in one table: Company Number | Period Start | Period End 1 | x | y 1 ...

I used OCR software to read the Names and addresses off ~500k images. For each image we received ID and Account Number combinations that correspond to a...

I need to know how to format a query to produce columns of "best fit" width. Specifically in a Xtab query. Please help, Frank

I've posted this before but now can't locate my post. I have a membership database in which I have a form created for input of general data on each member...

I have the following SQL that selects the TOP 10 clients by percentage of sales. I want to be able to SELECT the TOP 20, TOP 40, TOP 60, etc.. by entering a...

What type of query would i use in the following scenario... I have a table called UserPW, with PK UserPWID,autonumber, long; field ONID,text; field PW,...

I have a table that generates automatically from a constant data feed from a crystal grower. The pertinant data generated is the serial ID (RunID), Datetime...

I'm having a terrible time, this didn't sound difficult when I said I would do it but now I'm NOT able to make this work. I'm working on a database that keeps...

I want to capture the LONG date from a query, so I create a parameter for the date (mm ddd yy) . In its properties, it's format is long date, BUT it always...

Hi, I have a table where I have lists of colleges that my students have applied to as well as their status. The table has fields for student ID (foreign...

I have the following query sql statement (it works fine) SELECT tbl_cngu_fire.cngu_no, Max(tbl_cngu_fire.fire_date) AS fireDate, DateAdd("yyyy",1,) AS Due,...

I would like to update 2 fields with the following Where like "*BASIC*" update = "BASIC" and = "HITS" Where like "*FARE*" update = "FARE" and =...

Hi, I will require 5 tabs in the report. All reports should be able to use the same result set, but not all columns will appear in each report. They will just...

I have a very basic select query that list all the records from a table SELECT tbl_cngu.cngu_no, tbl_cngu_recalls.recall_no FROM tbl_cngu LEFT JOIN...