Search results

I have a nested IIF that I cannot get figured out. This is what I have so far: Hours: IIf([Dept]="10",55,Format(IIf([EorDCode]=" 1",[Regular]/60,[OT]/60),"Fixed")) The problem is that I need another IIF to differentiate between Regular and Overtime. It needs to do this. If Dept = 10 Then 55...

I have a table with data structured like this: Emp# ST OT -------------------- 30174 1421 540 30180 1882 518 30200 2400 0 30223 2271 66 I want to create a query that takes that data and does this: Emp# ST OT -------------------- 30174 1421 0 30174 0 540 30180 1882 0 30180 0 518 30200 2400 0...

Does anybody have some sample code or a turorial for exporting a datagrid into an Access database table?

I am trying to evaluate two IIfs in a report but have something wrong with the syntax. Here is what I have =IIf([InvUM]="EA" And [InvRoLevel]<=6,6,12, =IIF ([InvUM="Qt" and [InvRoLevel] <= 220,220,440) Basically the I want it to do the first evaluation if the InvUM field = EA and do the other...

I have a table with these 2 fields: Name and AnniversaryDate. What is the best way to write a query that will show me all the anniversaries that will fall within the next two weeks? For instance if I have a record with these values: Name, Anniversary BukHix, 1/1/2003 I want the query to look...

I have a table that holds time stamps like this: 1108 - 9:46:08 1108 - 9:49:47 1104 - 10:13:54 1105 - 11:41:53 1105 - 11:55:11 etc How do I just get the hours part of that field? Something like the following. 1108 9:46:08 - 9 1108 9:49:47 - 9 1104 10:13:54 - 10 1105 11:41:53 - 11 1105...

I have an address database where people have been allowed to type in any characters they want in place of just leaving a missing field blank. For instance the Zip code was not a required field (don't as me why because I don't know. It just wasn't) so over the years when the person entering the...

I am trying to consolidate data from a proprietary database that was built for a DOS based point of sale application. The database is basically a series of flat files. I have managed to get the data into SQL Server but I am having trouble getting the Joins correct so that the data shows the way...

I need some help setting up the relationship for this database in a VB.Net/Access project I am working on. Currently the relationship looks like this: Now I need to add one more table that will have a one to many relationship with the (history?) table: The history table has the...

I am pulling data from an application that allows duplicate customers (Not sure why but it does). Here is my SQL as it is: SELECT CUSTOMER.FIRSTNAME, CUSTOMER.LASTORCOMPNAME, CUSTOMER.ADDRSTR1, CUSTOMER.ADDRCITY, CUSTOMER.ADDRSTATE, Left([ADDRZIPANDEXT],5) AS Zip, HISTORY.CLOSEDATE...

I have a query where I need to check for a null in a numeric field. I did a search on this forum and found several threads with the answer. However, for some reason I can't get it to work. What am I doing wrong here? Vendx: IIf( isnull ([Vendor],999,[Vendor]) All I need to do is put a 999 in...

I am looking for a way to load a MDE from a Visual Basic .Net application. The MDE is an Access 2000 version and all the clients on my network are using Access 97. From this thread I found out that you can use a run time switch to overcome the version problem, however I am not sure how to set...

Record Number = current number of record I have a table that will be rebuilt every week with new data (batch table). I need to run a query on that table that will start at the first record giving a new field (the field name is BatchSeq) the value of 1 and then incrementing it one value for each...

I am back working in Access again and I have a very complicated problem. I am not even sure there is going to be an automated solution to this but if there is I need help figuring out how to do it. I have two tables that I need to make into one new table. Table A is the primary table. It has a...

I am trying to spin through a recordset removing the last character from each text value. The values are all - Here is what I have so far but it's not working. Can somebody show me where I went wrong or point me to a better way? Dim objDB As Database Dim objRS As Recordset Dim...

Has anybody started programming VB.Net as a front end for Access? I have an application where I am currently doing just that. I have some code in a current Access form that I would like to make work in my VB form but I am not sure how to do it. For instance running a query or transferring a...

I have two tables with exactly the same fields. There are 5 fields named: ID JobName JobNumb Location Title One tables has 4193 records and the other has 6957. The smaller of the two tables is the actual table that my application uses. Some how a bunch of records were deleted. I have an old...

I have a subform that shows all the records in my table. I also have an option group representing the 4 quarters of a year. I am trying to filter the data in the subform based on the current selected option. What is the best way to do this? Here is what I have so far I just need the proper...

I am trying to write code that looks at a field in a recordset. I want to check a string in the RS to see if it has a hyphen or a numeric character at the end of the string. If there is a hyphen like this 3493- I want to remove the hypen and leave 3493. If there is a letter like this 4893-A I...

Hey MS just started an Access Developer center so I thought I would pass it on to you all. The Access Developer Center! I haven’t had the chance to see if there is anything useful on it yet.