User Profile

Collapse

Profile Sidebar

Collapse
clevelander
clevelander
Last Activity: Feb 27 '07, 06:31 PM
Joined: Feb 4 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • clevelander
    started a topic Add Field to Table using Access Macro

    Add Field to Table using Access Macro

    Hi,

    Is there a way to add a permanent field to a table using a macro? I have a number of different tables that I need to add the same field name to, then I update that field based on info in the table, and append them all into one big table. It would be very helpful if I didn't have to go into the design view of each table to add these fields. I'm a novice when it comes to code, but any help would be greatly appreciated!!
    ...
    See more | Go to post

  • Help: Can't add two fields in a query unless data in both

    Hi,

    I am hoping you can help me with an Access problem I am having. I have a query where I am trying to add two fields from a table. For some reason, I only get a result when there is data in both fields. Example:

    Code:
    Field_A      Field_B      Query_addition_result:
    2               4                6
    5                                 
                    7                
    8               1
    ...
    See more | Go to post
    Last edited by NeoPa; Feb 5 '07, 12:47 AM. Reason: Tags for Layout
No activity results to display
Show More
Working...