Search results for query: *

Hi, I am writing a query and trying to convert the date to print the 3 letters month and the 4 digit year. This is the column code Entered Month: Format(Month([Suggestions].[date_entered]),"MMM") & " " & Year([Suggestions].[Date_Entered]) It does print but a different month altogether not...

Hi, I am moving a simple batch file with a few FTP commands to copy a test file from a Unix box to a mapped drive on the Win 2K PC. It was working on the WIN XP PC that I developed the script on. But now I am getting an error on the WIN 2K PC that says: Log in incorrect, invalid command. Do I...

Hi, Using MS Access 2003 I have some functions that I created in module long time a go. I am getting a compile error on all of them on the loop line. The error said "Compile Error: Loop without do". They were working at some point. I think I am missing a reference library or something...

Hi, Using MS Access 2003. I have a formula in a field that looks like this: =([Curr_Vis_Out]-[Prev_Vis_Out])/[Prev_Vis_Out] to get the percent of a change between two periods. I am getting a 0 if either fields is a zero value. How can I program this to accommodate when the zero is in the...

Hi, I have a field on the report that holds numeric values. I formatted it to show standard numbers with 0 decimals. But it is not showing the thousands separator. When I go try to change the format property, the drop down does not show any options now. Not sure what changed it and how to...

Hi, I am working with MS Access 2003. I am trying to get a total of a field where the value of another field = to a certain value: For example this is the report: Name, Count, State AAA 5 CA AAB 4 AZ AZA 10 CA ACA 3 CA I am looking to get a sum of the counts...

Hi, My boss asked me to create an access database to manage the inventory of some sample products that we receive from vendors. My challenge is adding to the current inventory and deducting from the stock when something is dispensed. I created the tables and the forms and they look good. But...

Hi (MS Excel 2003). This happens to me once in a while and not sure why. I copy some information in a spreadsheet and try to format the column to a currency format. I hit the $ button from the top but it does not show the $ sign or correct decimal points. I go to format cell and choose...

Hi, I have a table that looks like this: Name Number Date Event1 Event2 AAAA 455 1/1/01 A A AAAA 455 3/2/02 B A AAAA 455 8/3/05 C J BBBB 123 3/5/02 A G BBBB 123 8/2/04 K N I am looking to write a query to get the earliest record...

Hi, I work in a shop where almost all the computers are loaded with MS Access 2000 and MS Access 2003. I created an application using MS Access 2003 tables and forms. But when they click on the database shortcut it opens in MS Access 2000 by default and get errors. Is there a way I can change...

Hi, I have this line of code in a module: sqlMonth = "SELECT MIN(NumberOfMonths) as LastPostMonth FROM PCS_BUDGET_PATS_LIST GROUP BY PATNM HAVING PATNM = " & rst!PATNM I first got an error that there is an extra comma because the actual data value in the rst!PATNM has a comma. I tried to do...

Hi, I have a column that has data that looks like this: 5/19/1999 6/4/1998 11/4/2001 12/13/2005 I would like to write an update query that would insert only the month and the year in a new column called PostMMYYYY. The new column would have these values: 51999 61998 112001 122005 Please...

Hi, I jusd reformatted my laptop hard drive and installed WIN2K and in the process of installing the drivers. I installed the drivers for the wirless card and it seems to be working. It found my wireless network and the laptop got an ip address. But when I open the internet browser, it does not...

Hi, I reformatted my laptop's hard drive and downloaded the manufacturer's drivers but they don't seem to work. When I open the device manager, everything is updaetd except for the Eathernet Controller, PCI Serial Port, and Unknow device. I tried many times and can't fix them. I am more...

Hi, I have a table that looks like this; KeyField CPT DESCRIPTION EFFDATE AMT 1 10006 PARONYCHIA,COMPLEX 01-Jan-96 $110.00 2 10007 PARONYCHIA,SIMPLE 01-Jan-96 $70.00 3 10021 FINE NEEDLE ASPIRATION;W/O IMAGING 01-May-06 $239.00 4 10033 DIGITAL BLOCK 01-Jan-96 $26.00 5 10040 ACNE SURGERY 01-Jan-96...

Hi, I am trying to put a criteria in the where clause to select records if the entry has a value in the cents digits (to the right of the decimal point). I can remember a way to do that. Please help. Thanks Mo

Hi, I have a large file and trying to categorize the data in a certain column. I think there is a way that I used long time ago that you can, in a query, put a value in a new field called CAT1 if the value of the evaluted field falls between 1 and 4. Can you pleas help refresh my memory...

Hi, I am writing a script in VBA to pull some values from an Excel spread sheet to update a Unix program using Attachemate Reflection. I am getting the error above on the file path line. I can't see anything wrong with it. Did anyone get this error before and was able to fix it? Thanks...

Hi, Is there away in excel 2003 that I can do nested subtotals. I am able to subtotal on one field by going to Data/Subtotals. But not able to do it on more than one field. Thanks Mo

Hi, (using MS Access 2003) I created a query with a new field to calculate the difference between posting date and current date. The calculation seems to be working fin but when I add > 35 in the criteria, it has no affect. I expect the query to skip any records that have less than or = 35...