Search results for query: *

Thanks very much for you help LesPaul Ive figured it out and it is doing what I want it to do. Kind regards Alphil2001 (star well earned)[2thumbsup]

Hi Leslie Thanks for your quick response. the table has a List of dates and offices as fields ID ID Field Date1 Date Of Transaction Office1 Office Name Type1 Type of Sale Date2 Date Of Transaction Office2 Office Name Type2 Type of Sale Date3 Date Of...

Sorry Alphil2001 here again Forgot to mention that the queries were Union SQL queries which pull information from one table and sums the total number of transactions on given dates Thanks hope you can help Alphil2001

Hi, Ive searched through the forums and cant seem find anything that may help me. I have over 30 seperate queries, Each query is the result of looking through another query and table and returning the last transaction date and transaction number and each query returns a different number of...

Hi AvesRule33 I managed to get it to work but a little differently for what I was wanting it to do. At first I had unbound fileds with the =[combobox].column(1) to bring over the value which worked fine but it wouldnt pass the value over to the append query. The solution I found was to...

Thanks AlexCuse and IGPCS Ill have alook into this and try it Thanks for all your help Alphil2001

Hi All Hope you can help with this one I have been going round in circles trying to figure it out. I have a form called Add Student which has a number of text boxes to allow the information to be entered. First Name Last Name Mobile Telephone Office (Combo box list of offices) Address...

Hi all I have a problem, im quite new to the SQL part of access and stored procedures so please be gentle with me. I have an access database which is has a number tables which holds information about different things. One is a Service table, one for Inspections and one for Applications all...

Thanks Mike will do

Hi all I have a problem, im quite new to the SQL part of access and stored procedures so please be gentle with me. I have a database which is has a number tables which holds information about different things. One is a Service table, one for Inspections and one for Applications all linked by...

Thanks very much PHV, I will try it and let you know, Your help is very much appreciated, your a star!!! Alphil

Hi All, hope you can help, I have a single table and form or records which log the date and number of transactions. What i would like to know is it is possible to select the date of a transaction and for access to show the last date this transaction happened. IE date 13 july 05 (col 1)...

I have a spreadsheet in excel that calculates the time and records working hours of a staff member. I have a calculation that adds up the time for the week but when I try and take the flexy time away from the time worked it sometimes comes up with a minus. This is what I want it to do but it...

I am trying to get access to store a value in a text box that has been populated from three differnt fields, one being a combo box. 1.I have a date field 2.a time field 3.and a combo box with product details. 4.I have managed to combine the three field values into another text field called...