Search results for query: *

Ok sure, Sometimes a mail merge is powered by a query that could be stored in your access database. This is a static query which cannot be changed and is bound to the document. Now what i was thinking was if i built the sql statement in vb.net, and open the mailmerge document sending through...

Hi experts, Any ideas how i can send a query through so that it powers a mail merge document in ms word? Any help much apreciated guys and gals, Al

Hi experts, i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it...

Hi experts, i have set up a mail merge in ms word, and have linked it to a query in my access 97 database. Now i want to be able to change a parameter in the query, i.e. CarNo(a number which is unique to each record). How is it best to send this to the query/word document - at the moment it...

Interesting.. looks good, it's just my date problem, let me explain in more detail. The user will pick a year and period. From that i calculate back 13 periods, so for example... If the user chooses Year 2006, period 8 - ihave the following years and dates:- actualYear actualPeriod 2005...

No i haven't - i'm runing the code from vb.net so writing the statement in there. How would a crosstab help me?

Could i put a year in the IIf(iperiod=9,1,0) statement somewhere? IIf(iyear = 2005(iperiod=9,1,0))?

There will be records in the database for all periods years, so there will be from year 2004-2006 and each may have data for each period(1-13)

Sorry, it does return values, but the date issue still stands. Heres some sample data;- BaseDataId supplierId originIsCustomer dateRaised supplierResponse dateCARsent dateResponseReceived dateCARclosed daysToClose statusIsOpen weigtedIncidentresult impactId iyear iperiod 63 33 True...

Right i see now - the thing is that the iDate sometimes changes from 2005 to 2006, i also tried rning the statement but it doesn't return values for the second and third part of the query, just the first part...

Thanks, whats the 9,1,0 in Sum(IIf(iperiod=9,1,0))?

Hi, At the moment i have 13 seperate statements selecting a count of records depending on the criteria dates. A few are shown below:- SELECT count(impactID) as period1 FROM tblBaseData WHERE iyear = 2005 AND iperiod = 9 AND impactId = 1 SELECT count(impactID) as period1 FROM tblBaseData...

Hi, VB makes my dates from my datetimepicker into the format mm/dd/yyyy instead of dd/mm/yyyy like i want. Heres how i put the value into a variable to use:- Dim dtResponseReceivedTo As Date = dtpTo.Value.Date I need dd/mm/yyyy, this is how its stored in my access97 database - am usingvis...

its cool, just orddered the sql like u said

cool, can i get the sort property to sort a column when i load the datagrid?

hi i have a datagrid all set up, i just need to know how to sort on one of the columns, for example supplierName... I've put my code below to show you how i have it set up. Cheers, al dtAudits = ds.Tables("audits") ' present data With dgAudits...

Hi, I am using a dateTimePicker to select dates so that they can be used in criteria for a query. The problem i'm having is that when i select a date, the current time comes with it, so when searching on the database if a record has say inserted with a date of 01/01/2006 12:04:33, i may search...

PS also tried @@ identity

Can i do this sql statement? sql2 = "INSERT INTO tblmaterialSupplier (materialId, SupplierID) values (SELECT @identity FROM tblmaterials, '" & intSuppId & "')" I can't get this sql to work - i need to get the last enetered materialId from my materials table... Alex

forget last post