Recent content by ashkjohnson

Oh my goodness, I totally missed that! You were correct, the texts were not identical. theDBguy you are the best! This made my Friday! MAHALO!, Ashley

Hi DBguy! Thanks so much for the quick response. Your suggestion worked flawlessly for the dates!I entered =[Start Date] And =[End Date] into the controls of 2 textboxes. But, this works for the other parameter, but with an additional user step: For this criteria: Like "*" & [For which...

Hello, I am working on making a report header more descriptive for a user. I have a report that was built from a query. In that query I had set parameters for the user to define results.I want the user to have record of the criteria used when using the report. The criteria are: Like "*" & [For...

Hello June7! Oh my goodness, it works! Thank you so much! I had tried that formula in a different footer and it didn't work. Wow, I had no idea the placement of the formula in a certain area mattered! Forgive me, I am not a programmer. Thanks again!!! Ashley Johnson

Hello, I am having difficulty with creating a final, grand total on my report. In my report I have groups that have their own subtotals. I would like to take those earlier subtotals and sum them for a grand total. In each group, I have on my report a section including three text fields and...

Happy Friday! I tried to join the lookup table into the individual queries by adding tables to the grid. I am clear on the instructions, but I think the joins I am using are incorrect because the data reported are not expected. I am not sure which join I should use. I need some help before I...

Thanks for the help, I will try it. And thanks for catching that duplicate thread. I noticed the prompt message of approval after the second submission. - Ashley

Hi Adam, Thanks! I agree, sometimes it's best to be self-taught. I have learned soooo much online. Gosh, not sure what I would do without the internet. - Ashley

Hi pbaldy and theDBguy! Nice to meet you both! Hawaii is pretty awesome, but I do like some cold weather once in a while. I love snowboarding! But, let me be clear, I like temperatures warmer than 20C. Hahaha

Thanks for your reply pbaldy! Sorry, I am so Access illiterate. How do I Add the lookup table to the grid with the appropriate join? I am pretty sure I understand your approach, I just don't know how to deal with specifics. And what which join would I use? Thanks again!

Hello! I am very new to access and not a programmer. But, I need some help with a union query. BACKGROUND: I have a union query that is working, however two of the columns report back values from the primary key (default unique ID column). I do NOT want the primary keys' values, I want the...

Aloha, I am a new member to this community, with absolutely no background in programming. I live in the beautiful state of Hawaii. My very, very, very basic knowledge of Access has come from my experiences at work. Although, I am not an IT person, I have genuinely enjoyed learning about Access...