Fields Show Numbers instead of the Text/Names

[gheyman]

I am new, so please be patient.

I created a query that uses to fields from a Table. The first one is a List of Task (there are intended duplicates) and then Due Dates.

I changed the query into Aggregate (Totals) Query were I want the Max Dates. When I run the Query it turns the Task Names into numbers. The Right Max dates are showing assuming the numbers are some alternate for the Tasks.

Can anyone tell me why I get numbers. Someone once mentioned it had to do with the Long Interger, but that didn't help me any

 

[Joe4]

Can post post a small sample of what you table data looks like, and then a small sample of what you query is returning so we can better understand what you are seeing?

 

[gheyman]

I have a query that is one field "Task". Its contents are listed below

Task
Administrative
Bid NoBid Meeting
BOE File Creation
Design Concept Development

In a table I did a field that is a Lookup Wizard to this Field/Query and set it so Multiple choices can be made.

When you are in the table in that field and select the pull down the list with a check box shows as
28
2
10
5
30

 

[Micron]

In a table I did a field that is a Lookup Wizard to this Field/Query and set it so Multiple choices can be made.
When you are in the table in that field and select the pull down the list with a check box shows as
28
2
10
5
30

In your original post, you don't say what numbers you're getting - the ones you list here?
The sums (or counts or what? you don't divulge what's in the totals query for that field). You are likely either getting the result of an aggregate function on your field (remove the aggregate function) or it's the wrong field, or maybe it's the hidden index of your lookup field. Creating lookup fields in tables is a no-no if you ask most experience Access designers. Here's why
The Access Web - The Evils of Lookup Fields in Tables
Plus, you really should not be adding/editing data directly in tables. It also reads like you're using a multi-value field

Multiple choices can be made

Sorry to say that's even worse than lookup fields. I know, you're wondering why the h-e double hockey sticks does Access provide these options if they're so bad. Beats me.