Search results

  1. M

    Exporting A Query containing a SWITCH function - unable....

    Hi There, I have a Marco that outputs a CSV file. This Marco previously used a standard query. However, the client requested that depending on a result the column's value will be x, or, y etc etc. So, I have the new query that contains a SWITCH function. The query runs fine via the...
  2. M

    SubForm RecordSet Uneditable based on query structure! But I need it :/

    Hi There. Hopefully I can clearly explain my woe. Problem: I have a Main Form and a SubForm. The SubForm contains fields to a table (Booking Item) that records - Qty, Item ID, Booking_Id Description and Price. The Subform source is a query that gets the details from the following Tables...
  3. M

    SUM function produces Error from calculated function

    Hi there, I have a project at hand and it's been a predecessor of mine (you know where I'm going, yeah?) and client has asked me to do some work on it and extend functionality - but I have not really delved into Access before and I have had to worked my way through to this final snag :/ A...
Back
Top Bottom