Search results

This worked great thank you so much for the help! I hope you have a great day!

Hi All! I am wanting to pull the value from a field in a query to be displayed in a textbox. As seen in the image attached I tried referencing it as follows "[qry_SPL3]![fld_IDIT]" but this just gives me the "#Name?" error also as seen in attached. Below is what the Query I am trying to pull...

Awesome, thank you very much! I figured there would be a function for it. Have a great day!

Hi All! I am just wondering if there is a method of only pulling numbers from a field in an Access query. Basically, I want to be able to use a field with just the numbers as a means of sorting and filtering later on in this database but I can't use Left() or Right() (to my knowledge anyway) as...

Thank you so much this worked perfectly! I really appreciate your help, and I hope you have a great day!

Hi All, I am trying to count only the unique values in a specific column in my query. The field I am trying to count unique values for is the field "fld_CrNo". I have tried using SELECT DISTINCT but to no avail. There may be something more complex I need to implement in order to get it working...

Hi All. I am building a database that houses my grades with the intention of displaying my average grade per semester. The problem is that my field "fld_Smst". The data stored in this field goes by season first, then year, so "Fall 2018" or "Winter 2019" for example. What I would like to do is...

The JOIN is what I was missing, lol. Sorry I'm operating on negative amounts of sleep right now, just been working on this personal project on the side with bogus data. Thanks for the help, sorry I'm stupid 😓.

Here is the SQL for Query 3

Hi all! I have two queries, one detailing the sum of revenue over three years and the other detailing the sum of expenses over three years. I want to have a query that shows the two sums beside each other along with the years. The two queries both only have three entries, but when I combine the...

Okay I didn't think so. What would be the best way for me to go about adding a description field in a table for the grouping codes? Ideally it would be for unique grouping codes only.

Apologies I attached the wrong reference image, that was for a different query entirely. I just updated the image, I can provide an image of the query data as well. See image for details on the query design.

Hi there, sorry for the late reply, been really busy with some other things lately, I tried to add what you said to the PARAMETERS in query design tab but it doesn't seem to be working. I have three fields on the query, one is the year, one is the grouping code (tags basically) and the last is...

I want to add a field called "Grouping Description" to a query that will detail the meaning of something called a grouping code (basically tags). The reason I want to do this in the query is because it contains only the distinct grouping codes so adding the description there would be much easier...

Hi everyone! I am currently in the process of making a graph that can be filtered based on values in a combo box. I build a query specifically for the graph that contains the year, the grouping codes associated with items (basically tags), and the total amount spent per grouping. Usually using...

Thanks! This worked perfectly, now to figure out how to make the chart look better... lol

Hi all! I'm having trouble finding a solid way to create a scatter graph from a query that would show the yearly amount spent on each grouping of items (for example amount spent on wood, computers etc.). I've been using mm/dd/yyyy format for the dates in the table the query is pulling from and I...

Ah my mistake, this worked wonders and has solved my dilemma, thank you so much!

Just took a look at the usage of the "DSum()" function and am a little confused. I tried doing "=DSum([Amount], [qry_Search])" but it doesn't work. Maybe I'm missing something, its late where I live so I also might just be tired. I appreciate any support.

I failed to mention that it still picks up the [Amount] field fine when in the Page Footer, but using the Sum expression for some reason causes an error.