Search results

Hello, I am trying to group a subreport field SID (integers) to a Main report field UID (integers) so they line up next to each other in the final report. They are not primary keys b/c their ID numbers are not unique. There are many more main report entries than subreport entries, but I still...

Hello, I have been told what I want to do cannot be done with Tables. Now I am wondering if it can be done in a report. I am trying to combine 2 Tables along a common field ID, but there are several issues. Each ID represents a city block and on each block there are many traffic signs...

Hello, I need some help writing a query. I have a table with street sign information. It has 10 fields. I would like to create a new field (an 11th) and have a new ID number for each unique entry in one of the 10 fields field. In other words, I want to create a new field called UNIQUE...

I admit I am a newbie and I am still using Access 2000, but I hope that means a lot of you will know the answer to this question. I have two tables (one older) with traffic sign information. They each have 8 fields. I want to do something like an Unmatched Query between the fields that define...