Search results

Need to run a query against a table to show entries that are whole integers. This is needed because some people have entered in the wrong currency due to a misunderstanding and the most probable illustration of this - a crude way of QAing

I have a query with lots of calculated fields that I want to pull into Excel for some managers to query. I have no problems with this for other queries but this one just throws up 'Numerical Value if out of Range' now there are calculated fields that are showing #error due to 0/0 type...

After developing my database for one specific reporting requirement I've now been asked to produce a series of reports all following the same basic structure, but I'm struggling to make sense of it (maybe I'm just too close to the old reports). Simplistic version of main table (tbl_DeptSales)...

Yet more help required. I've got a table thats used for tracking documents, with the following fields Organisation, QF_received, QF_checked, QF_imported, QS_received, QS_checked, QS_imported etc. I need to be able to run a report that will list all the organisations and then under each...

Hi I have got a query Organisation, Team,Quarter, Sales I'm trying to set up a form for our users to view this data for each team and need to be able to view it as follows: Org Qtr 1 Qtr 2 Sales On the form I've got text boxes with control set to 'Sum of Sales' but I need to only show...

Hi As I've previously posted in the Word forum - I've got a sectioned document (Word 2000) which I need to import into Access 2000. I've run a macro to separate each section into files and now I need to import specific files into specific fields in my table. Each file has been named as...

At the moment my DBA is on long term sick so I'm trying to figure this out for myself (I do the web frontend). Got a contact db with several tables and I'm trying to run a query to get all individual details with their associated org/base/directorate and related projects. Here's the query...

I'm developing a basic CMS for a small website and I'm just having some difficulty in getting my head around pulling the most recent entry to populate the page Here's my current query: SELECT tbl_page.PageTitle, tbl_content.PageContent, tbl_editor.EditorName, tbl_content.PublishDate...

Wondered if there was a solution to this problem: =Format$([Profilecreated],"mmmm yyyy",0,0) I want to show the expiry of the profile which would be 12 months from the date created. Do I just use DateAdd?