Search results

Sorry! Just re-read you entry and realised I've got it wrong way round. Above queries report on the HandHeld_Unit, whereas you want to report on the PageNo. These are queries you need. Query 1 - Same as above SELECT tblStockCount.PageNo, tblStockCount.Handheld_Unit FROM tblStockCount GROUP...

Think this will work for you. Need 3 queries: Query 1: SELECT tblStockCount.PageNo, tblStockCount.Handheld_Unit FROM tblStockCount GROUP BY tblStockCount.PageNo, tblStockCount.Handheld_Unit; This takes your data and picks up each occurence of HandHeld_Unit and PageNo. If a HandHeld_Unit...

You've tried to define a function inside a sub function. I'm guessing you want the export code to run from a button so you just need the sub function. Private Sub cmdtransfer_Click() Function test() <-- Delete this line DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, "ASP"...

Hi Barca The username and password should be saved in the ODBC connection, so you'd need to update the ODBC link with new password. It's also possible that this is contained with the Access database as a connection string, but I don't think this is so in your case. Personally, I'd ask IT to...

After playing around for a bit I've discovered the answer! I just need to recreate the functions in Crystal for each report.

Hi Barca Couple of things to check; Is the ODBC link still valid. From Control Panel -> Administrative Tool ->Data Sources ODBC. Click on Sage ODBC and run through configuration. You can click 'Test Connection' on last page to check connection ok. Has your version of Sage been updated? New...

Thanks Namliam I'll give that a go. I would like to know how I'd use the actual 'Roundup' function I'd written to rystal though, as I have a number of reports to move from Access to Crystal and most have some custom functions involved!! Thanks Leon

Hi I'm trying to link a query from access (or stored procedure in Crystal), into Crystal. Query is called 'LQClients' and is itself based upon a query called 'LQData' The query call a custom function called 'RoundUp' which just takes a number and round it up to nearest whole. This works...

Thanks SOS. Just installed and had quick look and seems just what I'm after. And the added bonus of a few new toys to play with!! Thanks Leon

Hi Does anyone know of an add-in (preferable free!) that will let you do a find/replace within SQL Designer? I work with a number of identically structured tables but with different names and often create a query for one table, then duplicate the query for another which means replacing all...

You can't do this within a query, but you could create a query on the fly in code: Function dynamictablename() Dim tblname As String Dim sql As String tblname = "tbl_EXTRACT" & Format(Now(), "ddmmyy") sql = "SELECT dummytable.* INTO " & tblname & " from dummytable;" DoCmd.RunSQL (sql) End...