Queries

Delete Query Help
I'm running a delete query that removes the records from table tblAllRecords when the PolNo is also found in a table called tblTransfer. When I run the query as a select query, it identifies 281 records to be deleted. When I run the query as a delete query, I get a messge box saying the query will delete 281 ... 11 May 2010 15:41

Ranking based on Multiple Data Fields
I am trying to Rank a field based on multiple sort criteria. My query sorts correctly, but the Ranking assignments are not correct. Could someone please review my SQL query and let me know how to correct this problem? I need to sort Descending by [Type2] AS WELL AS Descending by [Ext B/O] I used the fol... 24 May 2010 10:08

How can I refresh the master form from a subform?
Hello. On the After Update of the subform I am trying to refresh the Master form. I have tried things like Docmd.requery and Me.Refresh, but not sure what I am doing. Can you help me with this? Thanks. Iram ... 11 May 2010 13:25

Max Query
Hi all, I have 2 tables. One holds account numbers. One holds invoices, linked to account numbers. Ive got a query to show the latest invoice for each account number, via the MAX function. However, once this has been done, due to it being an aggregate function. There is no way of me editing this query once d... 17 May 2010 09:08

address in one line
Hi all, I am trying to get query to return record like follow: name 123 mian st. houston, tx 77082 USA but the result i get is as followed: name 123 main st. houston tx 77082 USA what do i need to chage in the query? the query as followed: SELECT vendor.VENDOR_NAME & Chr(10) & Chr(13) & vend... 11 May 2010 12:18

Combine field entries in new field
Is there a way in design view to run a query that will combine the entires of one field into another field? For instance, I have 1 field that is NAME and a second field which is DATA. For the same name there can be multiple DATA (A or B or C), which are alpha not numeric. I want craete a third field which eit... 11 May 2010 11:11

start date & end date - show all date in between
I have a date table & a leave table which leave table contains startdate & end_date. How i do show all date in between startdate & end date . For example : Leave startdate = 1/5/2010, end date =3/5/2010. i want the data show all date - 1/5/2010 NANCY AL 2/5/2010 NANCY AL 3/5/2010 NANCY AL ... 10 May 2010 23:13

Cumulative Percent
My intent is to add a field to my table that contains the cumulative percentage of the CumFreq field (cumulative frequency). Any help would be greatly appreciated. My source table 'AllinOne' looks like this: Speed,Frequency_Vehicles,CumFreq,WeekNum 10,1,1,31 13,1,2,31 14,1,3,31 17,3,6,31 20,1,7,31 Etc, etc... 11 May 2010 10:04

Output Query as an Excel file
I am trying to output a query as an excel file and save it to a specific location. Here is my code. DoCmd.OutputTo acOutputQuery, "Qry:SKU_ALL_2", acFormatXLS, _ "C:\RH DOC\LCM_PROJECT\LCM_QRY" & "\" & "LCM_QRY" & "_" & "PERIOD" & "_" & ([Forms]![LCM_DATA]![PER]) & ".xls", False I get a run time error '2306'... 10 May 2010 18:48

crosstab parameterized query
PARAMETERS FISCALMO IEEESingle; SELECT * FROM [01-GL History Query] WHERE ((([01-GL History Query].TYPE)=3) AND (([01-GL History Query].YRMODA) Like "10*")) ORDER BY [01-GL History Query].AMOUNT; There is my query where I finally got the parameter fixed where FISCALMO would prompt for the month. The crossta... 10 May 2010 16:34