Search results

hello, I want a query to run and output values on a certain date. I have created a form and inserted an activex component 'Microsoft Date & time picker'. But im stuck on how to get this component to be recognised by the query! Can anyone please help me out or suggest a different way? thanks...

Hello, I ve performed a query on a table and now have a set of results which is fine for example £1.56, £1.98, £87.90 (ive set the values in to a currency format), now i want to calculate the total so i have run another query on the last and used 'sum' in the 'total' this calculates the value...

thanks Brian, Ive partially sorted it. I uesd : IIf(IsNull([BOI]),"0",[BOI]) this works fine but i need it to set the other fields in the query to zero when the above one is zero. can you help me with that thanks iso

thanks for replying still cant get it to do what i want Thanks iso

Hello, I have a query which lists all values in a table which contain 'Y' these values are then all added together using sum. I then have another query which takes these values and adds them to some others from a different table. my queries output when containing a 'Y' field1 field2...

Hello Pat The values in the Combo are months like i said january,febuary etc... but the table contains the day and the month eg 03 january. how would you suggest i use the combo to select for instance any birthdays in january when the field 'birthday' contains 03 January, 09 January, 23...

hello, i am trying to use the above in the exprssion builder but it wont work, In the 'combo0' is a list of months - january, febuary etc and in the table is '04 january' in a normal SQL statement i would use: like '*whateverfield*' and that would do it but because im using an access forms...

thanks guys, decided to seperate them.

Hello, i have a table with a field containing peoples 'names' for example - David Moore is there anyway of doing a query on this so it lists the contents in order of the surname. Thanks for your time iso

Is there anyway of configuring an ODBC driver without going through all the control panel - add driver etc sequence? i mean is there not a line of code you can enter into the RUN command or a batch file? or as anybody designed a macro which will do this? thanks for any help iso