Search results

Hi Pat, Thank you for your reply. When I tried as you suggested it does not make any difference. I removed the Rnd function from the union query as well as the Top 5 SELECT tblASTDATA.[ID], tblASTDATA.[Weight], tblASTDATA.[StockCode], tblASTDATA.[CurrentQty] FROM tblASTDATA UNION SELECT...

Hi Paul, Thanks for getting back to me. I tried as you suggested entering CurrentDb.TableDefs("STDATA").DateCreated as the control source for an unbound text box, but when I view the report the box is blank and the code changes to CurrentDb.[TableDefs("STDATA")] when I look at its properties...

Hi Paul, Thank you for your response. I have a button in a form that a users clicks on to import the data. The date of the last import would suit my needs. Can the import date be displayed on a report? Thanks.

Hi, I have 3 queries that I need to join. the 3 queries work on their own. They are all similar to below SELECT TOP 5 ASTDATA.[ID], ASTDATA.[Weight], ASTDATA.[StockCode], ASTDATA.[CurrentQty], Rnd([ID]) AS Expr1 FROM ASTDATA ORDER BY Rnd([ID]); But when I join them, like below, the data...

Hi, I have a database created that imports data (stock levels) from a text file into a table and then email various suppliers with the current stock levels. The emails are all scheduled using scripts. The weakest part of my set up is the text file, I am depending on someone remembering to run...

Hi Guus2005, Apologies in the delay getting back to you. Thanks for your suggestion. One of the tables the query was running on had a couple of duplicates in it causing the problems for me. It is all sorted again. Thanks again for your help.

Hi, I inherited a database recently and all was fine until about a week ago. The database that is giving trouble generates a report using a query. The query looks up a table and generates the data so it can be shown in a table and chart on a report. The query lists all the different areas on...