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...

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, 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...

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