Search results

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