Recent content by mdubravic

Reason why I am not directly importing is that I do not full access to that 3rd party system, and we need some more options that that system doesn't have. I have only date from excel sheet. Actualy we do have API that we can use and import data directly, but I do not how to that in access.

HI, everything is working but I have different problem now: as I use third pary system from there I am downloading all my reservations in excel. That excel file I linked to Access and I created CreateTable Query that creates table with all data. What I want to do is that our sales team can...

I think I found solution! Thank you!

I manage to create what you provided and implement it. But still there are some issues that bother me. In this query that you provided to me I have total sum for PropertyId. That is great if I want to present that. But I need to report monthly or weekly something like this: PropertId 1111...

So as I understood your example you created composite key in table so that you can handle same PropertyIds and put them as PrimaryKey. But what when I got new reservation in my table PropertyUsage? I do not see results in your query. Thanks!

Hi, thank you very much!!! That is exactly i need. I am now trying to implement this in my database. For now this is the greatest help I got on the web. :):):)

Hi jdraw I have similar issue but little more complex than that and I posted it here access-programmers.co.uk/forums/showthread.php?t=273070

Thanks I posted my first question here access-programmers.co.uk/forums/showthread.php?t=273070

Hi, I have this issue: I have two excel tables that I linked in access. From excel tables I created query that gives me all data I need. First table has data of periods and prices of apartment per period. For example: PropertyID 1111 PropertyName Apartment Zagreb Mila StaringDateOfPeriod...

Hi, I work for small travel company and my job is to be sure that all technical stuff to works smoothly :) I stuck with one issue in our database in Access and so I am hear to seek your answers. I am relay exited to get answer for my issue as you are giving help to other users also as I could...