Search results

Hi I'm trying to finish a query that calculates the time worked in the AM and PM, adds them together, then takes that away from the standard working day. I've done everything else, but when I take the hours worked away from the standard day it always ends up with a positive number, regardless...

Hi I'm trying to run a bit of code changing each record, starting at the begining of my database and stopping at the end. I've looked at a For...Next, but then it doesn't start at the begining, and will only step to the TO number. Any ideas what I need please. Thanks Alan

Hi all Barclays give me the feature of downloading my statements in csv format. There are several fields, but the important being 'Amount'. I've imported into a table and added a 'debit' and 'Credit' field. So far so good When Barclay's data comes down debits are shown with a - (negative)...

I've got a database that records booking of Cars. I now need to show a 'Diary' I was thinking [Car_Reg_No] across the columns, [Hire_Date] on the rows and the [Time_Of_Hire] in the value area. Problem : Can't get the value [Time_Of_Hire] in crosstab. Any thoughts......Anyone Thanks

I've created a box on a form that opens another form (with one field 'Notes') 'on click'. I now need this box to change colour if there is any data in the notes field, so that the user can see if there are any notes to read. What code do I need, and where do I put it. Thanks for your time.

Been working on this for a few hours now, can't see the light. Two tables, one with a list of British Postcodes, one with a list of companies. Easy so far. Companies can cover several postcodes. and Postcodes can have several Companies. I need to relate them so when a postcode is chosen...