Search results for query: *

Having checked through the data tables, there are, indeed, fields labelled NUMBER, but this hasn't affected the creation of or results in other queries which use data in this field.

SumOfNumber is a generated field from other queries which count the total number of a product code, whether delivered (qry_DeliveryTotals) or sold (qry_SalesTotals).

Select

Well, I've now given up on trying to get that to work. I have now generated two queries as below: Query1_Delivery SELECT tbl_StockItems.[Model No], tbl_StockItems.Description, Nz([SumOfNumber],0) AS No_Delivered FROM qry_DeliveryTotals RIGHT JOIN tbl_StockItems ON qry_DeliveryTotals.[Model No]...

There are 3797 records in tbl_StockItems. I've tried changing the criteria, as suggested above, for the variable in_stock but all I now get is: The field is too small to accept the amount of data to attempted to add. Try inserting or pasting less data. Problem now is that, even if I revert...

Many thanks, but this script generates an error: The SELECT statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. I modified left to LEFT and the query runs but still doesn't include products where there have been no sales. What I...

I have been using the query below to try to provide an accurate stock level from two tables tbl_Delivery and tbl_Sale. I can produce results from 2 queries (qry_DelivertTotals and qry_SalesTotals) that summarise how many of each product have been delivered and how many have been sold. Whilst I...

There is probably a very simple answer to this problem ,but I have not been able to find anything in the HELP files I have for Excel which moves me towards a resolution. Basically I am using a LOOKUP function to connect the full address and event details (stored in Table 2) to a date and...

Fantastic Ken - thanks so much - have a star. John R

Many thanks Ken - I'll give this a try. I have been working on a version of my original idea that generates a new table and allows the user to view the contents. This works. The only thing I haven't managed to do is completely delete the temporary table; have only emptied the existing fields...

Thanks Ken Not quite the answer I wanted, though! Is there a way of doing what I want to do (i.e. finding duplicate records) using VBA, allowing users to search any field from any table (bearing in mind there are over 600 tables in the database!)? John R

Apart from the slightly different order of field specifications, can some kind individual tell me what the difference is between these two SQL statements? STATEMENT 1 SELECT GESTUCENTRES.SetId, GESTUCENTRES.StudentId, GESTUCENTRES.CandId, GESTUCENTRES.CentreId, GESTUCENTRES.CandNumber...

Thanks Guys for the help. I used Andrew's basic structure to solve the problem, but the second combo box content was dependent on the selection made in the first, so devised two procedures, as follows: Private Sub Form_Open(Cancel As Integer) Dim counter As Integer Dim table As...

I have two combo boxes on a form. The first box I want to populate with names of the tables in the database. The second combo box I want to populate with names of fields within the selected table. I know how to generate the list of tables, and the fields within them, but how do I get these...

Obviously not as easy as I thought! Gave up and recreated the option group. John R

I've been away from Access for a few months and feeling very rusty. There is probably a simple answer to this question, though I can't find anything in Access Help or in these forums. How do I edit an existing option group on a form? I have an option group with three tickboxes and now want to...

Try Me.txtLine.FontItalic = True John R

Don't know if you have solved this yet, but you could create a module, something like this: Public Sub Filesearch(Filename As String, Folder As String) Dim obj As AccessObject Set obj = Application.Filesearch With obj .LookIn = Folder .Filename = Filename If...

OK Jim I have created the scenario you paint but changed the listboxes to text boxes txtSigninDate has the data control source set to =DMax("[SigninDate]","tblSignin") txtStartDate has the data control source set to =DMax("[StartDate]","tblSignin") A...

Ken Your advice was spot on - worked for me to solve a similar problem. Have a star! John R