Search results

Hey guys!!! Everything is working fine with the query, only that now I wanted to make a criteria on a field to be true, when I put true and the field it gives MSG "HAVING clause (WorkOrders.NewCheckBox=-1)without grouping or aggregation." I am putting grouped by Expression and still get the...

Hey RV I think I got it !!! I have to put Group By = Expression!!!! YYYEEEEEEEHHHHHAAAAAA!!!! Rum and Coke baby!!!! DaniBoy

Hey RV it works great!!!! no more running I hope!! jajaja, Now when I select another field from the same table and drag it down to the query it gives me this Msg. "You tried to execute a query that does not include the specify expression 'AddressID'as part of an aggregate function. What does...

Nothing seems to be working!!!!!! I dont know what else to do!! The access bible does not show anything on this!! I tried what you guys told me and nothing. I cant believe this is kicking my but!!!!! It should be a simple query!! Man am MAD!!!!! I did the what you told me David, but I gat a date...

ok, i just found out that no matter what I group the DateCompleted field by, I always get the same answer. What is up with this thing!!! Am gonna go run around the block!!!!!!! DaniBoy

sorry!! this is what am doing. I have a work order database where the tblWorkOrders has a WO# field DateCompleted field and the addressID, all the rest of the fields I realy dont use on the query. I want to run a query where the results are going to be the lastest completaion date for an address...

Thanks guys, But I think I confused you guys. I am only using one table and I want to find the latest date on the "DateCompleted" field. This means that when I run the query I should get only the last record entered. DaniBoy

Hello Guys, Well I have looked in all the Q&A and cant seem to find what I need!!! Its simple but I cant get it to work. I have a query that searches for the same IDnumber in two tables and only list the ones that match. I also want it to give me only the IDnumber with the latest date. I did...

I tried that code but it didnt work, anymore ideas?!! Daniel

Hello, I have a form where i have three check boxes. Whe am putting a record in one of the three chkboxes has to be true before I can save the record. I tried some if statements but didnt work. Here is what I tried: Private Sub Form_beforeUpdate(Cancel As Integer) If chkNew.Value = False And...

Anyone else has any idea how to do the above?!! Thanks

Yes, only use the parameter once, this means, put the between [Beginning Date] and [Ending Date] on the query Date field, then i you want the date to be on the report, put 2 unbound textboxes and put [Beginning Date] on the controlsource of one and [Ending Date] on the other. They have to be the...

Thanks Rich It works when I use it on the detail section, but I want to be able to use it on the page header. When I put it there the data is an error. Any more ideas? Thanks DaniBoy

Need help with Dcount "Urgent" need this report Hello I have a report made from a query called ResponseDetail where I have 6 fields that the report uses. 2 of the fields are dates and 4 are checkboxes. The name of the query is ResponseDetail and one of the checkbox name is "Bulk" I need to...

Sorry Pat, I know that now, It wont happen again!! DaniBoy

Hello, I have a query where my expression is "DateResponse - DateRec" this gives me how many days it took for someting to get done. Now I could easyly make three more queries with to get dif criterias for this field. But I want to be able to find the total of records from 0 or 1 day, and the...

What if the field on is an Expresiion?!! DaniBoy

Hello, I want to update or add new records on a table from another table with out it duplicating what do I use and how? Updating primary keys Daniel

Hello, If I append one table's field to the primary key of another table with data on it already and no duplicates, it should just update the the new information right? it will not duplicated? right? Let me know

Thanks Jack, But what about the workorder number? They want me to make the work order number start from 0 every year.