Unanswered: Import a new column in query and add to the report
Hi there, Newbie to Access and have got a problem with a report i require for work ??
In work we have a macro to download a report every 15mins, which is then imported into my database. So we have one table called [Data Import]
I have a load query which updates the time and date on the imported data to the current time when loaded.
I have then got a cross query which takes information, extracts only todays date and supplies the number of workorders by Branch , with a column of the time the report was received.
In the database attached the query 'rqryLocareportforday' shows the above.
When i create a web page in the wizard the info is shown correctly and i can lay it out and complete required arithmetic, ie (9am count - 8.15am count), conditional formating...etc
Problem is each time new data is imported, a new column is added, and the data can not find the label in the template report.
Is there a way this can be performed, so that the data when recieved, the form creates a new heading (10:15PM, 11:30PM etc ) for this data and adds it on to the report/webpage in such a way that i can use the details to complete some simple arithmatic on the form also ???????
I have attached the download address for my zipped db, the cross query is [qryLocareportforday]which supplies the data