Search results

What I want to do is from several records find the Max() date and update that one record with my stuff. However, I get an error message cannot use aggregate in update query or something to do that effect. Is there a way to get around this?

basically I have two date columns in one of my tables. One is created whenever a record is created in that table the other is added to that record later based on business rules. I need to get all records in the table where the first date exists but not the second. I'm unsure of how to write a...

Ha take that, I created a new table thru a new table query that didn't have duplicates and based it off that.

help, this is driving me insane! (resolved) My query looks like this...The problem is that when I have one Radio with two records where [Defect fixed?] is false it counts that as two separate radios instead of one. Somehow I need to make it sum records with the same Radio/Serial_number as...

at one point in my database I have two tables and for everyone record in one table I may have either 1 or 0 records in the other. How do I express this in access design? Since it's an optional 1 to 1 relationship I guess?

I pass them via form. I figured it out. or rather I found this website and stole the code... http://support.microsoft.com/default.aspx?scid=kb;en-us;328320 it works now.. only thing I can't figure out is why it insists on 11 columns and headers. but that doesn't matter since only the...

I'm having big trouble creating a report based on a crosstab query I have that asks for a start date and an ending date. Basically what's happening is that when I create one, the boxes for the parameters start popping up in the middle of design view! and they just keep coming... Is it even...

I FIGURED IT OUT, WEEE, I have to create the parameter, but then I also have to go down and enter it below the date field. that's what i was missing, thanks.

the variable name is not [?]. this was what I was using as a criteria, but it could very well be something like between [Start Date] and [End Date] With this I get a message saying 'Microsoft engine does not recognize [Start Date] as a valid field name or expression.' see what I mean?

yeh, I did change the date field however problem is the same this is the access generated sql TRANSFORM Count(Defect_Log.[Defect type]) AS [CountOfDefect type] SELECT Defect_Log.[Defect type] FROM Defect_Log WHERE (((Defect_Log.Defect_Date)=[?])) GROUP BY Defect_Log.[Defect type]...

My question involves the table below AutoNumber(primary key) SerialNumber Station Defect Type Date Basically now I need to be able to get the result i've gotten by a date range, but the crosstab query won't let me do it the way you can in a regular select query...help...

Ha I figured it out, instead of having a separate date field just create a criteria in one of the other fields...problem seems to be solved. THANKS...

well, um bit of a problem now, i'm able to get all the passes and fails, but I'm running into a problem with getting them by the date... I'm getting the error below you tried to execute a query that does not include the specified expression date as part of an aggregate function this is my...

I LOVE YOU MAN! hehe, (little dance of joy)

Date is when Serial number was input into the system. I have three tables PartNumber with fields PN(primary) (description) (type) There are only 62 part numbers (ever) There are many serial numbers to each part number so second table is like so SN(primary key) PN(foreign) Station1...

oh I just posted some random stuff. just wanted to show some info. it's more like this... st1: st2: st3: st4: Date: serial#(primarykey) pass pass fail NA 10/21/05 s23434324 pass fail NA NA 10/22/05...

never mind I just realized that it's a problem to be handled by the front end and not the fault of back end Db. i'm a newb sorry. If I shout out my three tables out here could you give me some more suggestions on what to change?

well, actually I designed the db and it's possible to change it. But I also designed the application in vb.net that uses it as a back-end. I can't really think of a good way to implement it the way you describe because of certain business rules. such as a station can't be passed if the...

One of the tables in the database has these fields st1: st2: st3: st4: Date: pass fail fail pass 10/21/05 fail pass fail pass 10/22/05 and so on. What I need to do is extract the number of passes and fails on each of the four stations and put them into a report. User will...

no, it's a primary key