I have a table that contains the date/time for each record How would i write a query so i could show the records for the first day of each month Likewise to...

I'm running a query in Access2000 while connected to an Oracle database via the MS ODBC driver for oracle. I receive the following error message: ODBC--call...

I have a table of Sales Projections (tblProjections) to which several employees are to enter their comments regarding the projections (tblComments). I have a...

I am trying to make a query that calculates a weekly handicap score for the players in my league. Each player has a handicap based upon their score each week....

Hi - I have a problem with an SQL statement I am trying to execute in VBA. This SQL statement was generated by the 'Design Query' tool in Access. The error...

Hello, I am rephrasing/simplifying a question I posted earlier so that somebody might know what's going wrong. I am using two action queries in a form. A...

Hello, I have a one to many db design.. when i add two related tables to a query i get data when i an a third related table i only get column heads? i am...

I updated ODBC drivers for SQL software and two commands will not function within Access 2000 query: Date() and Right (substring command)and possibly some...

I have forms in Excel where I can browse for files of any type, populate a textbox with the file chosen. Then later work with it. Is there a way with Access...

I have a db that I use to track mileages. How do I make a query that displays two different totals: the current months totals to date and the weekly total to...

Hi all Is it possible to do this in MS Access? select (distinct fieldname) from ... If not, is there an alternative? Thanks in advance

How to use a loop? I had problem querying the number of yes or no, to a table? I need to display a table based from the 3 fields from a table(branchinfo)....

How to create a query that shows duplicate records?

When i start up my pc a lot of applications start up at the same time e.g. quicktime player, kodak , casio photoloader etc . They are shown in the taskbar...

Hi Everyone, Stupid question here, but does anyone know how to get just the date out of a date time field? All of the examples lean toward DD, or MM, but I...

Hi, I am using an Access 2002 query to link to a word 2003 mail merge. I have used the "confirm conversion at open" method but still cannot see the...

Hi, I have a query that is summing up column A which is formatted as Number-Double in it's current table. The results of the query should show up as 0, but...

I have a form based on a query of several tables but I could not update the fields of the table in the query. I used to be able to do that...is there something...

Can anyone tell me how to automatically connect to SQL server? I am always prompted for a Login ID and Password on the SQL Server Login Windows. Use Trusted...

Hi There, I have a query that uses the Date\Time function and displays it as DD\MM\YY HH:MM:SS. I'm trying to extract any occurance of where the time is 30...