Search results

Hi again, can't seem to work this one out, despite searching through the forum and trying several suggestions. To summarise what I have. In tblMaster I have a field called GoLiveDate - formatted as Date/Time in the table. In qryMaster I have a calculated field DateReceivedTarget that works...

Cheers Rabbie. I'll check the formatting and have another search of the forums.

Hi I've had a search through the forum but can't find anything to solve my issue. Hope someone can help with this one. I want to filter a query (ultimately a report) based on date parameters entered by the user (start date & end date) on a form. I've done this plenty of times before with no...

Thanks guys, really appreciate the help. Problem solved even when I explained it wrong!

Hi Hope someone can help with this. Had a search through the forums but nothing quite the same (although I'm guessing it's a simple one to solve.) I need to calculate a figure based on 2 criteria. The permutations are as follows If condition A is less than 20 and condition B is No then...

Hi again Bilbo I followed your instructions but have hit a snag. When the code tries to run I get a "Enter Parameter Value" box asking for "User_Input.Desc_1". If you click OK it asks for "User_Input.Desc_2" etc through to 4 and then produces a Runtime error 3113 - Cannot update Desc_1 -...

Fantastic stuff! I'll give it a try and let you know how I get on.

Hi chaps Thanks for the replies, excellent stuff. Bilbo - it is as you imagine - the data needs to come out of the Access database to eventually be imported into a SAP database and the SAP people tell me that they need the product descriptions in (up to) 10 chunks of 72 characters. I agree...

Hello everyone I'm fairly new to Access and hope someone can help with this problem. It strikes me as something incredibly simple to solve but my brain seems unable to provide a solution today. I've had a good look through the forums but can't find the answer. I have a form to enter details...

Hi Thanks for your reply. I think I explained what I was trying to do very badly (or maybe I didn't and I'm just stupid!) Anyway, I still can't work it out. I've attached a screenshot of the 2 queries and the results I'm getting. You can see that the count is based on a Where criteria - Yes...

Hope someone can help with this. I'm sure it's dead simple but it's driving me insane! The scenario is a number of departments who are processing something (sales for example). So, for October Dept 1 - 20 (Sales) Dept 2 - 10 Dept 3 - 2 Dept 4 - 7 Now I want to count the number of sales...