Search results

SELECT TOP 5 Sasol_Campaign_history.[Store Name] FROM Sasol_Campaign_history ORDER BY Sasol_Campaign_history.txtDate DESC , Sasol_Campaign_history.[Store Name]; Thanks guys

yep i do have a timestamp...(date & time)

Is there a way i can display the 5 last storenames i've saved? Like the myrecent document in ms office Pls kindly help Regards Noks

Got it DoCmd.GoToControl "page1" noks

The first tab has the clients personal details (which i don't make any changes to unless it's necessary) then the second tab consists of question (questionnare) then as soon as i fiil them in i save them. after saving i want the screen to authomatically go to the first tab so that i can see the...

Hi I wanna display the first tab after saving. Can you please let know how do i go about doing that Regards Noks

1) The control source is [Store name] as well as the field 2) txtDate is the name of both the field and control source [my fields r bound 2 my table so their control source is the tabe name] 3) It's the form Noks

I've changed it to txtDate but now it displays it fo each and every customer even the ones that don't hav the history. Pls help Noks

Hi Can you please help me with my code. I'm trying to display only the dates that are available in the history table fo the customer displayed in the screen & it's not working Here's my code: SELECT DISTINCT date FROM Sasol_campaign_history WHERE sasol_master_campaign.[store...

thank you. It worked perfectly Regards Noks

Hi I want to execute certain actions (ie. select an option and deselect certain options) when i click next record on my tab. Where should i put my coding coz if i put it on form load it's only executed when i load the form but i want it to be executed everytime i go to the next record Regards Noks

Thanks Curtis. Gr8ly appreciated...

Hi guys Is it possible to insert data into a word document. ie whenever a user takes a certain action - data should be added into the word document (which will b in a shared folder) If so can u pls kindly assist Noks

Thanks grandpa :)

Hi guys Am not sure if i've posted this issue in the right forum. If not pls let me know which 1 is. I'm interested in workin in Datawharehousing or BI, so i was wondering how do i go about that. (As in which courses can i take and which books can i use). I am currently a developer. Pls...

i finally got it. I needed 2 use the query windows and not the query design CODE: SELECT * FROM ( SELECT C.Customercode, O.OrderDate, O.OrderNumber, ROW_NUMBER() OVER ( PARTITION BY C.CustomerCode ORDER BY O.OrderDate DESC ) AS RecID from Customer C Left Outer Join Sales K on...

Group by doesn't seem to be making any difference. How do i use a loop in SQL server. Pls kindly advise, even if it's a syntax. (my first time using SQL server so am kinda lost) Pls help

Hi SQL Hell, yeah i subscribed to both just to be on the safe side :) I'll try yo advise Thanks

I get what u're sayin, but i need d last 3 orders from each and every customer. if i hav 10 the results should be 10*3 thanks

Sorry my mistake. it's 2005. Yes the invoice is incremental. I've tried using TOP predicate (SELECT Top 3...) but i only get 3 rows. It's the first time i'm using it so am not sure if my syntax is incorrect or what CODE: SELECT TOP (3) OrderDate, OrderNumber, OrderStatus, QuantityOrdered...