Search results

Awesome, This worked: Val1: DLookUp("Value128","tblCode128A","[128A]='" & [Expr1] & "'") Thanks a lot June7

Hello All, I have an issue with using Dlookup in a query, it is giving the wrong result back. If someone could help please? Reference Table (all the fields are Short Text): The Dlookup: Val1: DLookUp("Value128","tblCode128A"," ' 128A=" & [Expr1] & " ' ") The result (wrong): In the...

Thanks a lot all. The crosstab query is working. Now i was doing this also so i could create a combo graph. What would be the trick in order to allocate last year's sales to the Primary axis and current sales to Secondary axis please? So you can visually see the difference in sales for each...

Thanks a lot :)

Hello All, Could you please give me a push in the right direction? Thanks, Greg

Hello Pat, sorry, i missed your previous comment at 10:20 am. Unfortunately, i do not have the option to edit the test in a query as the file has two parts to it, a header and the data set. (or i wouldn't know how to achieve that). It's too bad, because at the moment, if i could get all the...

Thank you for your prompt reply, unfortunately, i still get the following message...

Hello, actually, once this is saved as a CSV, how do i make sure it gets closed please? With the current code, i end up with two files, the .xls and the .csv, but the latter stays open in the background.

Thank you very much for the help. worked :)

Hello, I am trying to adjust the code below (that works) so I end up with a .csv instead of a .xls Each attempt to replace the .xls with .csv resulted Run-time error '3027' Cannot update, Database or Object is read only. Could someone help me figure out what i am missing please? Private Sub...