Search results

Hey guys, Having a bit of an issue with this dsum. I used to have this code with a table that contained records for that year only. Now I am combining all years into one table. My dsum code on my form is returning a value for that month as normal but now it includes the month for every year...

Thanks pbaldy. I think I will stick with adp.. ill have to find another method for this query I guess.

Ah, I see. Thanks for the explanation. Would you recommend using accdb with linked tables instead? Will parameter queries such as [] function the same that way?

I have been unable to find the answer to this question, nobody seems to know so perhaps its not possible? I switched my database over to adp format so it runs on sql, I had a parameter query that I would like to use on this new database. In regular Access, it's just [] in the criteria field to...

as i said, its just a text field...

wait, are you thinking im using the primary key id column as a customer field? where did you get that idea? as i said multiple times, this is a TEXT field, that holes business name. NOT an int field, which would not allow letters. I dont know where you came up with that idea.

its just a field called [customer] with entries such as "mcdonalds" there is nothing wrong with that

so your saying that a text field is restricted to numbers only? ya... ok there is absolutely no reason i cant put things like "target" or "mcdonalds".

not sure where to start for that. you would think there is a simple solution just like normal access. doesnt get any easier than []... hopefully there is just a small bit of code im missing here.

correct. its a business name always, never people.

This designer does not graphically support the @Enter_Job_Number SQL construct. Id imagine it would be something like this though.. ill have to play around with it unless anyone knows?

why not? its relevant info.. its not like we have the address in there.

here is an example of one that works, you just want to see an example of one that functions properly? SELECT Quote, Customer, JobName, FollowUp, Date FROM dbo.Jobs WHERE (Quote LIKE 'M%') AND (Active = 0)

Indeed, i feel the jobs table is appropriate. we have a quote number, job number, customer name, and some other small data for the office. Nothing too in depth.

But access changes it every time. Then when I save it, it tells me there is no such field called Enter Your Name. Regardless of [] () '' "" stuff.

I think I have come up with a solution, just have another table with ALL of the material data etc. I was just worried beacause it will have like 50 records per job... and in 5 years we may have 5000 jobs... is this ok?

Yes it does. :)

Your code does not work. You must be using an access database, because that it what my old code looked like. This is now an adp, running on sql. When I enter this style code, access changed it to sql rendering is useless.

Its not.. that was just a mistake. The data is from table [Materials], query the field [Job]

Well thats the point of the post.. sql doesnt recognize the regular [] to initiate a input box like we used to use. I cant find anything to make this work in sql...