Search results

Sorry, but I couldn't get a clear picture of what is your requirement. As per my understanding, you have table where certain records need to be deleted. The criteria is DOB = X, where you enter the date X everytime you run the query. Another criteria is Name = Y, where again you enter Y and you...

Sorry, that is only the where clause of the query. The full query will look like... SELECT Table2.Age, Table2.Gender, Table2.Education FROM Table2 WHERE...

If you want a single parameter for the criteria, then it's going to be tougher manipulation of strings (because <, > have one char and <> has 2 chars, and hence you don't know how to extract) Instead I feel you can have two prompts, one for the operator and the other for the value. Then you can...

:) Sure. Don't forget to reflect your success or failure here. So that, others who view the thread are benefitted.

GalaxiomAtHome - Woww.. That's a lot more better than what I suggested.. Actually didn't see your reply before posting... :)

Generate the table in this format. This should be easy done with Excel. Later copy paste it. Year | Month | FisYr ------------------------ 2003 | 01 | 0304 2003 | 02 | 03042003 | 03 | 0304 2003 | 04 | 0405 2003 | 05 | 0405 ... ... till the...

This seems to be a standard bug with Access. Refer to this site. It provides the solution too. http://allenbrowne.com/bug-18.html

Huh huh... Memo field has that peculiar behavior. Sometimes, when the number of rows in your csv increases beyond a threshold (I think it is something around 65000 records), it starts behaving odd. Just try deleting your latest data in the source and recheck if the query works fine.

Also if possible, just copy paste your SQL query generated by Access. You will be able to see this if you select SQL view from the View menu.

I see that you have grouped columns haven't you?? That being said, just try overwriting the SQL generated in Access from Having(((CLMS004.[Claim ...)) to Having (CLMS004.[Claim Status Cd] in ("APPR","PEND")) Also if possible try converting the database to prior version or something, and...

Next in the query, how have you specified the criteria? In ("APPR","PEND") Like this?

I work with Access 97. I suppose, the file you have sent if of 03 or 07. So am not able to open it. Anyways I saw the excel sheet. I presume that Claim Rate Type is the text column that is troubling you. To start off with, first check the table structure in your Access table. See if you have...

You will have to use Crosstab queries to achieve what you desire. First you have to write an Intermediate query that converts your age and gender to age group and string notation that you require. That query is a normal query as given below. Inter_Query: SELECT...

Please specify the query and your table structure from which the query pulls data out.

if you have used it to denote duration, then you have to do some conversions after summing up, so that it makes sense. visit the following link for further information on this conversion. http://www.mvps.org/access/datetime/date0009.htm

this is time field. i.e. your field does not indicate 1hr and 15 minutes or the like. but instead it is 1:15am. the datatype you have provided is wrong.

But I'm not sure if this approach is going to work if your table consists one product & license pair as one record; i.e. only two columns in the table, with products repeating for multiple licenses. If that is the case then if Pdt A - Lic 1 Pdt A - Lic 2 Pdt B - Lic 1 Pdt B - Lic 3 is going to...

Hi. Try this query. I simulated a dupfind query in one of my databases and got the syntax. I couldn't however open the .accdb attachment.

No. 1 -> Join your two table properly. No. 2 -> Where is the group by clause in your query? It does not make sense to select a Max of something, without saying to group by some column. After defining the join, give group by VehicleId. Your answer should come...

can you tell the exact datatype of FlightTime column as in your access database??