Search results

Hi all, Sorry in advance for the long post. I'm designing a query based report in our Access 97 QA database that takes parameters from a user form. In the report header is a graph and beyond this graph is the detailed information for each defect. The graph shows what percentage each defect...

I can't figure out what I have wrong in my code. I've searched all over the forums and the help files in Access. I'm sure it's something simple. Could someone please take a look? =DSum([DefectQty],"d_sub1_DefectReport","CodeID= "" & [tblDefectCodes].[CodeID] & "" AND ""[InspectDate] >= #" &...

I have 2 identical databases with different data. The newer of the 2 databases was just for temporary use but we've decided to continue with the data that is in it. I would like to reseed the smaller of the databases starting with the last PK (autonumber) of the larger database and then append...

I have a parameter query that was discussed a while back Here where I needed help with a nested IIF statement returning multiple values. This has been working great until I was asked to add a couple more processes to the list. Now I get an error saying expression too complex. Ok, well I...

I have a 3rd party database where I have no control over how the data is entered. I've been given the task of creating a Crystal report that would need to gather data from two databases. The link between the two databases in my report would be on a quote number. In one database, the quote...

Hi all, I've used these forums immensely when I need help with my databases. Thank you for all the help you've provided so far. I'm hoping I can get some recommendations for my next database project. I'm getting ready to design a database that uses an ODBC connection to link to our ERP...