Search results

Hi, Thank you all for your suggestions, I have cracked it now

It would be 2 different strings really, so something like For Field 1 =LEFT(13),DLookUp("Caption","PLUCaption","Code='1318'") For Field 1 =RIGHT(13),DLookUp("Caption","PLUCaption","Code='1318'") If it helps I have 1 field (always 26 characters) which says "Pint of Lager ", I want...

Hi, Please can you help me find a way to display the left (or first) 13 characters of a field and also the right 13 characters in the same field as I need to display them separately in 2 different fields on a form. Below is what I have but cannot work out how to integrate left and right in to...

Thank you all for your suggestions, but thank you Arnelgp for your answer, this is what I was looking for. Very much appreciated!! Malcolm

Hi All, Thank you for your suggestions, but I am still struggling with this one, I have uploaded a demo database, could someone please be kind enough to have a look at this for me and put me out of my misery!! On the demo database, I have tried all sorts of formula's and still cannot get it to...

Hi, I'm trying to calculate the VAT Value and Net Value from Gross Value and VAT Rate in a query, however I cannot work out how to do this. I have a query which is going to update and transfer a table from MS Access 2007 to MS Access 2016 once I have worked out the VAT and Net Totals. I have...

Hi, The user can select up to 4 options\fields to display on the report and also a date range, effectively it is a diary system. At the moment it prints one report with 4 columns regardless of how many columns are required, however I wanted to go a step further and have a 1 column, 2 column...

Hi, I am trying to use 4 combo boxes to allow users to create and print a report. If combox 2,3 and 4 is null then it will print Report1(has only 1 column), if 3 and 4 are null then it will print Report2 (2 columns) otherwise it will print Report4 (4 columns) I am trying to use an if...

I'm trying to build a form which allows users to select up to 4 fields to build a custom report, so it would be dates down the side and up to 4 fields along the top. TheDate is a field in each table like the primary key, all headings (Table Field Names) are in a dropdown box for users to select...

Thank you!! Just one more question. Do you know if I can use multiple table sources in my SQL statement, IE: ... FROM Diary, Revenue WHERE ... Or can you think of how I can get data from multiple tables in to my one temp table? I am looking to create a temp table like the following: (Name...

I wondered if you or anyone else may be able to help me with this one too: I am looking to add in here to copy the data from another two text boxes, so it would be: Greater than or Equal to TextStartDate and Less than or Equal to TextEndDate DoCmd.RunSQL "INSERT INTO CustomRepData (Text1)...

Thank you, that worked a treat!!

I am looking to copy data to a temp table to compile a report. Users will select the date range and the criteria to use. I am looking for the user to select a criteria via a textbox in a form and to press print so the report is created. (Eg: if they put ToDoList in to the textbox then it will...

Hi Ranman, Thank you, I didn't think of this even although I have used this solution in other areas. I haven't had time to do all of this tonight, however I did quickly test it and it does work for what I need it to do!! Many thanks, Malcolm Hi Plog, The reason for the temporary table is that...

Hi, I am looking to run a report every day from data a temporary table, I am planning when a form opens it runs a few lines of code to fill the temporary table with various lines (different dates) for the report. The report will be a weekly revenue buildup, (Weekly heading across the top of...