Queries

Too many tables
Hi, I have a query that uses several subqueries. If I run this query several times I get the error of too many tables open. I don't have any tables open, and I only have this one query open. The only way around it is to close down the database and to start again. I'm thinking that for some reason the subqu... 2 Jul 2008 10:52

Crosstab Query Rows
Hi All, I am reporting on training and need to include YTD training for each month as well as the current month. Currently, I have a crosstab query which collates the YTD training, and another crosstab which collates the for the current month. I then combine them into one big query to report the now and befo... 2 Jul 2008 21:10

Make table query combining records of two tables into a third
Thank you very much. This did the trick, but I still had to work at it. I always have trouble with any coding. But I am OK now on this. Thanks again. "Michel Walsh" wrote: You said every FPDS.duns should be in CCR.duns. Every DUNS number in FPDS must be in CCR. But not every DUNS number in ... 1 Jul 2008 00:03

Selecting and counting records in one query
Hi there. I have a table with relatively simple data. If I build a query where the criteria uses the Like "*" & [Expr1] & "*" expression, it works fine and returns all the records. What I'd really like to do is for the query to provide a count of the matches rather that the records that match. So, instead o... 30 Jun 2008 19:57

display top 5 records for each subcategory
I need to know how to return just the top 5 DUs (Based on sum of cases lost) for each Code desc. Below is my current SQL that returns back all records for all CodeDesc Please help? Thanks! SELECT [(0005a1)InternalDrilldown - HPCStockAvail].CCFOT_SubCat, [(0005a1)InternalDrilldown - HPCStockAvail].CCFOT_... 2 Jul 2008 09:50

One Command Button for different reports
I am not sure if I am in the right Discussion Group, so here it is... I have five different queries called 'Cooling, Electric, Gas, Heat Pump and Oil' I would like to create a one command button on a form called 'Contract', that based on two fields on this form, called 'ContractNumber' and 'ContractType' will g... 30 Jun 2008 18:55

Sum values of column
I need to write an expression that sums the values of a query based on the date. Here is the query setup: Helo#(Dbl) Sample: 14701, 14702, 14703... Hours(Dbl) Sample: 1351.5, 1345.7, 1292.1,... 8-01(Dbl) Sample: 87.3, 88.5, 99.2... 8-02(Dbl) Sample: 87.5, 100, 100,... So, I would like to make an expression th... 1 Jul 2008 13:22

DSUM Syntax Error
I am getting the following suntax error: "Syntax error in string in query expression '[MonthNum]=6'""(second quote is not in the error screen). Here is my DSum expression: Test: DSum("Units","tblMonthlyUnits","[MonthNum]=" & CStr(DatePart("m",dhpreviousworkdaya(Date()))) & """"). The tblMonthlyUnits is set up a... 30 Jun 2008 16:52

Group By Qtr
I cant figure out how to group my records by quarters or months.Is there a special query to otain these results? My current SQL is pretty basic using two tables as the following: SELECT VendorInv.EnterDate, VendorInv.InvDesc, VendorInv.InvCode, VendorInv.InvAmt FROM Vendor INNER JOIN VendorInv ON Vendor.Vend... 30 Jun 2008 17:53

Help with a query...
Hello all, I have table Customer with the field CP I have the table Cpostal with the field CP_NUM The relation between this two tables is Customer.CP 1->N Cpostal.CP_NUM This means that the for one CP code in the table Customer i have N CP_NUM in the table Cpostal. My goal is update the field CP with the fi... 2 Jul 2008 11:54