Search results

I'm trying to create a form for users to grab data from a sales table. The form will show text boxes for a user to enter a start and end date. They'll then click a "search" button which will show the results in a subform. Apart from the fact I have no idea how to do it. I have created the...

Heh. Like I say, I don't really know SQL. I just assumed the TOP 20 automatically selects the highest figures...I'll give it a go. Ta, Steve

I have a table of sales figures and I want to extract the Top 20 results from [InvoiceValue]. I've tried something along the lines of; SELECT TOP 20 tblChelmsfordSales.InvoiceValue, <more fields...> FROM tblChelmsfordSales; but this doesn't appear to bring in the top twenty results from the...

I think I'm having a similar issue in the "Table Comparison" thread. It hasn't been fully answered yet, but you might find an answer or a prompter at least... Steve

I hate to hassle you again but I'm still having a problem. The query works fine (giving me totals for each year), but when running the report, I get #error for all of the calculations, and it's not grouping everything together like yours, so I get four lots of the errors (1 for each year...

Once again, I thank you. That's spot on, and will work with my database with no problems. One thing though...what does Module1 do? Cheers, Steve

:D See my edited post above...the .mdb you sent me before was different after all... Ste

Thanks for offering to take a closer look at this. It's very much appreciated. Don't know if you realise the .mdb in your previous post is exactly the same as the original .mdb you sent me! :eek: EDIT - Sorry...no it's not. That's not bad. Be interesting to see what you come up with after...

Well there ya go! There's my problem...I'm just over the Suffolk border and into Essex (I live in Great Yeldham now, which is about ten miles closer to you than Braintree). However, I am going to annoy you... The info you gave me was fab and I'm now getting the data I want...but... ...if I...

You, my near neighbour, are an absolute star. I think my problem is that I tend to make things more complicated than they should be. Thanks again! Steve

I have tblOrders which contains order data for the past few years. I've been trying several methods to create a report to compare the order data. The method I'm currently trying involves three make table queries that creates a table containing order data for a given AccountID in the format...

After all that, something so simple! Thanks all for your help. Regards, Steve

Neil, The hope was to convert all data currently residing in my Tables to a Date/Time format as opposed to Text. The initial data from the mainframe is technically a number (it's not in quotes to denote a text field, although the OrderDate field in the table is set as an 8 digit text field)...

Mile-O-Phile was kind enough to help me with a related problem regarding converting a Text field into a Date/Time field (format "YYYYMMDD"). This has led to the problem that now the field is Date/Time, the txt file that I try to import into this table won't work as "YYYYMMDD" isn't a default...

Smashing. That worked a treat. Thanks for your help! Ste

Thanks...I see how that works, but I'm not sure where or how I would implement it...I'm not too good on the coding side of things... Ste

I have a large database (so large in fact that it should probable be converted to a SQL backend), that was developed a few years ago. The tables import data from CSV files generated by our mainframe. This data contains dates (in the format "YYYYMMDD", so Jan 1st 2001 for example, would look...

Thanks guys. Much appreciated!

I have a reasonably complex database but the problem is with a simple part of it so I'm hoping there's a simple answer. I have a comma delimeted text file created by our mainframe every day that holds our customer account number (primary key) and customer name. This gets imported every day...

Wayne, Thanks for your response. It would seem however, that Access will call .EXE and .BAT files OK with the CALL statement, but the file we need to launch is a .SAP (it's shortcuts to a transaction within SAP). "Invalid Call Procedure or Argument" Maybe Access doesn't know what to do with...