Search results

  1. C

    D count issue

    Hi. Business quiet again so plodding along with my database. Trying to do a DCount in vba but having issues with error that keeps coming up. Background - initially i had a form with three combos. Category - genus - variety. Once i chose category it would run query to limit options in genus...
  2. C

    Using date to establish which column data goes in

    Yes many thanks for yours and Pats help on this one. Apologies i only explained it in stages i thought best that way but in hindsight i see it is all best to give the whole picture from the outset. Cheers for help
  3. C

    Why am i being asked for a parameter

    Hi JHB has kindly been helping me to solve a query issue i am having. I have tried to solve the last piece of puzzle myself and have got close however i am a bit confused with one element. I have created a query in query design using various expressions and when i click run it asks me to...
  4. C

    Using date to establish which column data goes in

    Hi JHB Please see the final desired look. Shown it in three steps. Step one more any sales made Step 2 showing the negative i am trying to remove and step three is what i am trying to achieve
  5. C

    Using date to establish which column data goes in

    Apologies. Uploaded wrong database. Now see correct one with query 3
  6. C

    Using date to establish which column data goes in

    Hi JHB\ THnaks for your continued help on this one, and we are getting so close to result required. I have posted new database. Run query 3 and that is what i am looking for. However there is one issue. At the moment say i have stock of potato of 1000 and 500 is currently available and 500...
  7. C

    Using date to establish which column data goes in

    Hi. Follow up to this. If i had a second table that was my sales invoices and then wanted to amend my query so it showed total plants gorwing / available and sold how could that be achieved. For example 2 batches of potato, 500 each. 1 is available 1 is still growing and i have sold 300...
  8. C

    Using date to establish which column data goes in

    SELECT Table1.ProductName, Sum(IIf([Date Available]>Date(),[QtyPotted],0)) AS Growing, Sum(IIf([Date Available]<Date(),[QtyPotted],0)) AS Available, Sum(Table1.QtyPotted) AS Total FROM Table1 GROUP BY Table1.ProductName;
  9. C

    Using date to establish which column data goes in

    Sorted last question myself. THanks for all your help
  10. C

    Using date to establish which column data goes in

    Last, question, hopefully. HOw can i adapt your if statement so that if it is null in an expression for gorwing or available it puts value 0 in rather than a blank.
  11. C

    Using date to establish which column data goes in

    Sorted it just made one change SELECT Table1.ProductName, Sum(IIf([Date Available]>Date(),[QtyPotted])) AS Growing, Sum(IIf([Date Available]<Date(),[QtyPotted])) AS Available, Sum(Table1.QtyPotted) AS Total FROM Table1 GROUP BY Table1.ProductName;
  12. C

    Using date to establish which column data goes in

    THat almost worked. Problem with that one is that it did everything right apart fomr the Available column. IN the growing column it say 2000 growing which is correct. In total column it says 3000 total which is correct but in available column it says 2000 available where it should be 1000...
  13. C

    Using date to establish which column data goes in

    its kind of what im looking for just not presented how i want. Rather than it have a status as field header i want the field header to say Growing. Another field header to say Available and another field header to say TOtal. Can that be achieved?
  14. C

    Using date to establish which column data goes in

    Hi PLease find example database. With basic data in table1 and i have created a query (query1) showing the heading results i am after but i am struggling to achieve the result i want under the available and growing heading.
  15. C

    Using date to establish which column data goes in

    Hi. Literally no clue where to start with this query so please bare with me. Lets say im in farming and i grow the following crops: potatos tomatos peas beans When i sow the above crops, i record on database the date the seeds were sown, what was sown, how many were sown and how long it...
  16. C

    Freetext search

    Apologies, now attached
  17. C

    Freetext search

    HI I have the attached main form. When i choose from any of the category, genus or variety comboboxes the below table filters accordingy using the attached query image. What i am trying to achieve is if i enter text in the search text box the three combobox clears (i can do this) but i have...
  18. C

    How to requery a sub subform when close a different form

    Hi Ridders. Following your advice yesterday i abandoned the nav form and built my own which now works just like the nav form but with my limited knowledge is proving easier for me to crack on with and keep developing my stock system.
  19. C

    How to requery a sub subform when close a different form

    Worked like a charm Minty. All bookmarked now. Many thanks for speedy response.
  20. C

    How to requery a sub subform when close a different form

    Hi. PReviously you guys have assisted me in requering a subform in a loaded form when i close another form. Works great. For example i have MainForm with a SubMainform which lists different products. On the mainform there is an add button that pops up another form - AddForm. When i close add...
Back
Top Bottom