Recent content by hinser13

I have two databases. 1: one Stored on shared drive and accessed by multiple users 2: 2nd Stored on Tablet PC Cdrive for field use I intend to use an append qry to to export data back into the main database following site visits and this is not a problem. The problem is: What is the...

I have 31 fields representing 31 days in the month and these are linked to month and year fields. so you get this in each fields: ="07" & " - " & [Month] & " - " & [Year] and then i get the day name by using this for each of the 31 days: =Format([Text253],"dddd"). However not all months have...

I am trying to set conditional formatting to colour a field if it does not display a day name, either: Monday, Tuesday, Wednesady, Thursday, Friday, Saturday or Sunday. I have tried the not between function Monday to sunday to no avail. Thanks Mark

I would like to know the best way to colour a field if a day of the week (Mon-Sund) is not displayed. Tried the between function Monday to sunday with no success, any ideas? Thanks mark

Dear All I am trying to use the sum function unsucessfully to subtract work completed values from the whole project value, if the true condition is ticked. =Sum(IIf([ValueWorkCompleted]=True,[TotalValueIncVAT]-[StatementOriginalValue)) This sould be, if the work is completed, subtract the...

I have a report I use as a statement of payments. I use the sum function to add the quotation values. Some are completed and invoiced some are not. The sum function adds all the quote values and there is a field that states invoice payment received (Yes/No value) Can I use conditional...

Dear All I have a query to find clients between a date range for the date quotes were sent. Currently when I run the query I have to enter a date past my target date to get the right results! I use a between dates criteria and want to find all the records sent on say the 19 Jan 2011. I...

Thank you paul, that works great ! Lastly how would you trim the following that does not include "Dear" followed by the field names, but only the field names: =([ClientHousenameornumber]) & " " & ([Clientaddress1])

Dear All I attach a screen shot of a report we use for invoices. The problem! If the client does not have a first name recorded a prenouced gap appears between the client title and surname. How do I get the text to push up if the client first name is missing. Her is the code I use...

I have two different databases and would like to import data from one database into the other. The Clients table in one database (database1) has different field names in the other client table (database2) I want to import all the client data from database 1 and currently can only think of...

I have 3 combo boxes used as look ups 1: Client ID 2: Surname 3: Company Name when you search any of the combo boxes and navigate to the account, the remaining combo boxes display the last search and not current client. I have found a way to set the form current event for 1 combo box but...

Figured it out! thanks again John

Thanks for replying John. Would I need to create a new table to control the form, with two fieilds as there are two criteria "Visit Date" & "Surveyor Name" for each of the 4 queries?

Hi All I have 4 seperate queries to extract data data from 4 seperate tables, using the same criteria each time: Inspection "date" and "surveyor name" At present I have to enter the same criteria 4 times, once for each querie. Is there a way to use the criteria once to run all 4 queries...

Thank you soo much, it works perfect!