Search results

Hi, I understand this information is like bread and butter (basics) for some, but I don't want to make any mistakes so I'd rather ask for support and thank you in advance for your time. I have linked tables from SQL Server using ODBC connection that their location never changes. I have used...

Hi spikepl, Thank you for your reply. With my knowledge of msaccess I might confuse myself and confuse you also :-). What I currently have is, I have linked tables (not imported) through ODBC connection. Now, for each linked table I have created queries to call only the fields I need, then...

Hi, I am working on an MSACCESS database that reads data from SQL Server through ODBC Connection. I have multiple tables that I have linked in and created Queries that read the data and created Make Table query. However, I am asking if there's a way to bring the data through a query that...

Usually on one MS Excel forum I use, there is a place / link to donate money to the Excel Guru's that helped with resolving the task / project and as a way to say thanks a donation can be done. Is there such thing in this forum where the participating MS Access guru's that will solve the...

In this case I won't be able to index many fields since the tables are coming from SQL Server through ODBC connection from tables that I do not control, and are controlled from the finance team, but when I check on the tables that I bring on the query's couple of fields have the key assigned to...

I tried the code that was given to me and it gave me syntax error, so what I'm doing now is I'm just trying the first part of the code and see if it works From the last code that was given to me I am only trying this part to see if that returns the '00' and MAX values of the column PR34005...

Hi, I will try this query once I get to office since I am trying the database through VPN connection to map to office network and it is going very very slow. I will get back to office on Sunday and try this. I really appreciate your time on helping me on this task. I hope we can make this query...

Here are the snapshots. As you can see on Slide1, it shows that I already have PR34002, PR34003, PR34006 and PR34009 already filtering data that I need as end result. After all these filtering, in addition I need the PR34005 which is the estimate revision, to show me the result of what is the...

@CJ_London and @vbaInet Thank you very much for helping me on this task. I will try to explain all the fields hopefully I will be able to. The field named qryPR34_UNION.PR34001 is my ProjectID number and basically at the end once all filters are done, I will filter/sort by that field to see the...

Hi jdraw, I am new to the msaccess forums therefore I didn't know to which one to hold on to. I thought it was just like years ago when I needed excel help I went to multiple forums and now for Excel I only stayed with two chandoo.org and smallman.com where I found Guru's which will work on a...

For example I have a table query that showing me currently in one column the following records: 00 01 02 03 04 *1 *2 *3 *4 So, there are thousand of rows associated with different project numbers so what I am looking to get is for example from the above records I wrote I want the query to show...

Hi, I have a screenshot of two slides that explain how my select query looks and what is the table/query showing now, but I can't upload the snapshots. I am clicking on the picture logo and it asks me for a http link

Thank you for your time to response. I can't attach a file otherwise I would send a sample database. What I'm trying to achieve is that I have a select query that is reading from a table and it already has some criteria's on the query like >0 and <0 on certain columns. The issue I am facing is...

I am stuck on this query for three days now. I really am desperate for help on this task so I can move forward with building my database. All I need is to know in the WHERE syntax, how will I need to add also an OR command where qryPR34_UNION.PR34005 returns the "00" (not min but 00) value or...

HI, I am having an issue with a select query as I want one column to show the MAX and "00" value of the same Column. How do I go about having this task completed. Any help is greatly apprecaited For example, the column has 00,01,02,03,04,05,*1,*2,*3,*4,*5 so I want a query that will help me...

Hi, I am in need of consultation for MS Access reading data from ODBC connection. I have SQL Server that has all the data for the project financials etc. I need a database that will read only certain data from the tables, for example, I don't need to import all 500,000 lines from SQL through...