Search results

Hi, hoping someone can help. I'm trying to create a list of codes with their description using two Access tables. Table 1 contains various code ranges From: 10021 To: 10646 and From: 20240 To:20550 and so forth. Table 2 contains all the codes from 10000 to 99999 with their description. I want...

I have the following Access report: Status Expected Actual % of Expected % of Total Expected Completed 2,552,068 531,061 21.06% (531,061/2787,154) syntax? In Progress 235,086 44,205 18.80% (Status footer) Grand Total 2,787,154 575,266 (Report footer) The formula for % expected =...

I need to make some fields Read Only by all Users in a Table while other fields can be updated for the same record. Is there a way to do this in the table properties without having to create a form? I'd appreciate any information you can anyone can provide. Thanks! emmorel

I've been an Access User for over 10 years; primarily use Access to import and export clinical data, sort and summarize data in reports. However for the past 5 years I've been developing databases for various purposes: collection of research data, creating surveys & datasheets, generating...