Search results

If I execute the query as it it looks great. Shows all my orders, my original column, and then the new column feeding data from the module. All information looks good including the module information provided above. As soon as I try to highlight a field and filter the "50 Count" boxes to get a...

WhatKit([Kits]) AS KITS2. Sorry KITS2 not KIT2. My entire SQL code is listed above. That is exactly how it looks.

it is a Long Integer so I made the recommended changes and I still get the same error when I try to filter the results. I can filter the KIT column but not the KIT2 column that has the new data from the module.

This is what I have... ~~~

I have everthing working great via the sample provided. Now when I try to filter anything I get "Data type mismatch in criteria expression" is there any fix to that? Did I do anything wrong?

OK great I will give that a go and see if I can make it work. THANK YOU BOB!!!

because I don't know how. I am happy to learn learn if that is the best way to do it. Where would I find a sample code of a similar situation?

In my query I have Exp1: Switch([Kits]=1,"1Box",[Kits]=2,"10Box",[Kits]=3,"10Box",[Kits]=4,"10Box",[Kits]=5,"10Box") I have an orders table where I list how many KITS each customer orders. Can be any number from 1 to 100. Well I use one of 4 boxes to send the orders and I am trying to get a...

I have a entry form with a dropdown for a field [CompanyName] We have alot of clients with very similar names. example: Steve's Auto Parts Steve's Party Supply Steve's Plumbing Steve's Plumbing of Boston Steve's Welding, Inc. My users have made it a habbit to select the wrong company while...

If IsNull(DLookup("Result", "tbl_HISTORY", "ClientCode = '" & Me.CustomerCode & "' AND Result = 'USA'")) Then Me.Detail.BackColor = -2147483633 Else Me.Detail.BackColor = 255 End If So this says if my client is from the USA then make my form go red. I want to make a...

Thank you. I went to add that and I think this will be a little more complicated than I thought. Here is my current SQL vlaue for my query Switch(([AD_DDate]>=#1/1/2007# And [AD_ADate]>=#1/1/2007#) Or [Approved]=-1,'PASS') AS PASS, How could I change these two values from 1/1/2007 to current...

I need to see all values in a date field [SalesDate] for all of this year and all of the previous year. I know this will show me all of the previous year Year([SalesDate]) = Year(Date()) - 1 But how do I show all of this year and all of he previous year as well? thanks.

I have a couple Access DBs that I want to convert to backend SQL. Are there any great step by step tutorials out there to help? After I convert the tables to SQL what is the best practice for the front end. Leave it MDB, switch it to an ADP, convert to something brand new? I just do not know.

Yes it is.

I think that is going to work. I added one more condition. SELECT T1.* FROM tbl_FINAL T1 WHERE T1.CompOrderDate = (SELECT MAX(T2.CompOrderDate) FROM tbl_FINAL T2 WHERE T2.CompName = T1.CompName AND T2.CompOrderType = "ONLINE" AND T2.CompLocation = T1.CompLocation); This...

Ya I know it makes no sense. I thank you for making an attempt. Maybe instead of trying to build it from scratch all jacked up I should ask my question a little better. I have a table with these fields: AccID (primary key) CompName CompLocation CompEmail CompPhone CompOrderType CompOrderDate...

I am trying to write a complex query filtering data from a large table and I am having problems. I am going to work on this in baby steps so I can figure out how to do this correctly. Here is my first subquery. SELECT [tbl_FINAL].CompName, [tbl_FINAL].CompLocation FROM tbl_FINAL WHERE (SELECT...

You are correct on all accounts and I know the best practice would be to switch to SQL which I will do within the next few months. I was hoping to get another project finished NOW set up without the SQL backend. I will go another route. Thanks.

Why is it not a great idea?

I am running 2 Access DBs in house. I am getting ready to build a new website and I want to use SQL backend on my server. I cannot convert the access dbs to sql for various reasons. So is it possible to have a SQL Express Server running on my hosting server and have Access Database in-house...