Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Chart in reports


  • Please log in to reply

#1
Mina

Mina

    New Member

  • Member
  • Pip
  • 1 posts
Hi,
I am trying to create a chart in a report based on a query. My query runs after I select a date range and the customer's name from a dialog box and it comes up with four fields: Customers name, Date, Department and Purchase Total. Now I am trying to create a column chart that has the Date and the Purchase Total. For each Date there is more than one Department and I would like that to show in those columns but it wouldn't work. Through the wizard I choose the three fields (Date, Purchase total and Department) but when I run it I get an error message; something like Microsoft Jet Database doesn't recognize one of the fields in the dialog box that I use to select the Name and Date range)! I don't understand what's that supposed to mean. When I change the Chart to a Line chart or I select only two fields from my query it does work.
Would please let me what am I doing wrong? this is driving me crazy. Thank you
  • 0

Advertisements


#2
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
Hello Mina and welcome to Geeks to Go!

Are you using Microsoft Access or Excel? Could you show us the query that you have generated? In Access (if you're using it), in query design for your query, go to View | SQL View. You can then copy-paste the SQL statement to your reply.

This also might help:
ACC2000: Errors Concatenating Variables or Controls

If you're using Excel, go into Microsoft Query (right-click data and choose Edit Query) to view the query.

If possible, specify data types for the parameters of the query. Also make sure you have spelled the field names correctly.

Regards,

Ax
  • 0

#3
hfcg

hfcg

    The hippie freak computer geek

  • Member
  • PipPipPipPipPip
  • 2,496 posts
I am sorry that I have not gotten back to you.
I know so little (nothing) about Access that I do not even understand what you said. :)
I am going to look for a tutorial for creating a Database with Access.
Thank you for your time.
  • 0

#4
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
:)

I'm pretty confused, who are you talking to hfcg? From your post, it sounds like you are the OP, but you aren't. Please clear up any confusion, as this inquiry has already been answered a week ago and I haven't yet received a response from the OP.

Ax
  • 0

#5
hfcg

hfcg

    The hippie freak computer geek

  • Member
  • PipPipPipPipPip
  • 2,496 posts
:) I do not believe that I put this in this topic.
Wrong topic.
  • 0

#6
Ax238

Ax238

    Tech Staff

  • Technician
  • 1,323 posts
No problem, I understand, thanks for clearing that up. :)
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP