Recent content by unclefink

ok so I should have better explained my origional post resulting all of the clarifications; however that is OK because this is all part of my learning adventure. I have a single table I'm pulling from that has a field called "CaseNumber". A case number will start with one of four acronyms...

I'm trying to create 3 like fields on a form that show the last 5 field records for "casenumber" in a specific table. I'm trying to get this accomplished without having to create new "sub queries". I am able to accomplish this with some sql but i'm trying to apply this to three different form...

Thank you so much for the second pair of eyes and most importantly sharing the wisdom to getting this solved. My Eyes very much appreciate it.

I've got an existing report that is dependent on an extremely large daisy chain of queries that I built a number of years ago when I was just learning Access and building a new database at that point. I'm trying to recreate the same report as I need to change the "work week" from what it was...

if it helps at all, here is a snippet of the data table i'm trying to "dsum". See attached.

Re: DSum with Multiple criteria The query seems to be working, its just not adding both criteria. As for the reference to multiple queries, i'm only using 1 query NOT multiple, I overlooked that reference on my initial creating this string.

Subject should say DSUM with multiple criteria, sorry. I'm having a hard time getting this criteria to work for me. I have a table called Extractsales that contains the following Fields: RecordID SalesDate ItemSold - This is referenced to the id of an item in another table NumberSold...

Thank you very much everyone, I have solved the issue based on your feedback. I appreciate your help

How should I put that in syntax if I want to count the number of records from that field while applying the filter.

Not too sure I understand your question.

case number is a text field. Our case numbers start with a site designation followed by a sequential number. My initial intent of doing this was to use a little as queries as possible. When I built this first report I was a beginner on building access db's and now i'm updating the same report...

I added the dsum syntax you suggested and am getting an error on run. Pictures attached.

I'm trying to do this without creating a ton of queries to get my ending desired results. I'll give the dsum function a shot but now i'm going to ask for assistance with translating to this function. I have a table called MainDataTbl In that table there is a field called casenumber Case...

I just updated the report to come from a query and also updated the query to only show me data for the last 3 years as that is all I need for this particular report. Doing so, I now have 1,961 pages for 8k records. As far as the report goes, where is the appropriate place to put the data...

I do have it in the details section. I guess i need to start there.