Search results

@CJ_London i've gone with generating an excel file report as that is what the clients are used to. in this instance there isn't really a good way to group things, maybe remove the 1st column as tbh they are the customer and should know their own name ;) thanks all for your...

@The_Doc_Man i'm certainly leaning toward 2 reports to stop the faffing around with page formatting between pages but with the second report definitely being wider that an A4 landscape i'm not sure how to achieve things in a pdf so maybe exporting directly to an excel file will be better

looking around and reading further would this be the way to go: https://answers.microsoft.com/en-us/msoffice/forum/all/vba-to-export-a-report-as-excel-file/d2270e6d-fe00-4103-914f-f0d99f301ef1 so i create the report as i want and don't mind it won't fit on a page i'll export it to an excel...

Hi All I am migrating my companies business away from running from a spreadsheet to an access database. As part of that I am recreating the reports that they produce as separate sheets from the data they have inputted. One of the reports has a letter template with details of a delivery as the...

AHAAAAAAAAAA @CJ_London yes this solved it thank you soooooo much

On the left is the results of the left join, the right is the inner join. When i've reviewed things the list of IDs on the right are exactly the right list, as you can see on the left there are claim amounts documented which means they have Credit Notes linked to them as well

ok so when i change Old SQL SELECT [FACT-DeliveryProducts].* FROM [FACT-DeliveryProducts] INNER JOIN qryAllDeliveredProductsWithINVWithoutCN ON [FACT-DeliveryProducts].del_prod_id = qryAllDeliveredProductsWithINVWithoutCN.del_prod_id; to New SQL SELECT [FACT-DeliveryProducts].* FROM...

@arnelgp noted, i'll give that a try thank you

it doesn't seem to like the [FACT-DeliveryProducts].del_prod_id of the WHERE of the EXISTS clause saying i'm guessing because the query uses the table as well there might be some confusion when its trying to resolve the EXISTS clause

@CJ_London i'll give that a try thank you

Hi All need some assistance in understanding and help with directions on how best to achieve the outcome i require here is a diagram to try to describe the situation i have to cope with: What we have is a consignment of products that get split into deliveries to clients and each delivery...

@CJ_London ok so things i have found so far: the second option you suggest won't work for my main form right now as it opens in acDialog mode which means the next line won't run till i exit the form so it won't set the records for the form the first option proved "interesting" in that when the...

@CJ_London this helps alot, i will try out what you suggested, i'd like to definitely improve the way things are done so this will certainly help, i'll update when i've added it to confirm that i've understood what you have supplied, once again thank you

@plog just to confirm i've implemented this in my actual project and its given me the results i was looking for so just wanted to follow up to thank you once again

@CJ_London thank you for your detailed reply. and i think where my lack of understanding and worry is coming from is basically highlighted by your final paragraph. Currently i have a continuous form which gives the user a view of currently in progress deliveries with a bit of summary...

@plog brilliant, and makes perfect sense now its laid out in front of me, i can apply this to my actual project to give me the results i want so cool thank you

@plog right ok, that makes sense

@isladogs i'll take a look, i'm not entirely sure i understand but i'll take a look and see what happens

Hi All another query question thats hopefully a bit different but possible. I have created a very simplified version of what i want to achieve so i can post screen shots/table designs/data and whatever else necessary. I set up a deliveries table defined as: And is populated as follows: I...

ok this helps in some senses as it kind of stops me worrying over things when i shouldn't, thank you for your help