Search results

Wow I am really confused. I have no clue how to make this work!

I am missing something. Please let me know if I am completely off track - I am fairly new to Access and am trying to teach myself. I'm comparing Person Contacted (Table 3) to Name (Table 2) Dlookup("[Person Contacted]", "Table 2, "[Person Contacted]=[Name]") Either way, what error message...

I am not sure how those two functions works. i am not sure what they mean by doman and criteria in the definition of the functions. Could you by chance explain really quickly?

I need some help. table 1 - site name and info table 2 - site personnel info (each site can have more than one personnel so it is tied to table 1 with an ID) table 3 - phone contact details (in the form, everything fills out automatically for the site info but i need to be able to enter the...

I need some help. table 1 - site name and info table 2 - site personnel info (each site can have more than one personnel so it is tied to table 1 with an ID) table 3 - phone contact details (in the form, everything fills out automatically for the site info but i need to be able to enter the...

Thank you so much!!! It works!

I have a question. I have a table that has a field date issued and one date mailed. Of course date mailed will always be greater than or equal to date issued. I want to put a validation into the table (I did that so certain fields cannot be left empty) but i get an error about not being able to...

I am trying to figure out the international phone number issue and I have no clue what all of the above means (I am really new to access) Could someone please explain it to me??? Thanks

That does not work. I think I figured it out though using an outer join!

I am not really sure how to do that but here is what i do know. Table 1 - ID (primary key), Site, Mailling Address, Shipping Address Etc. Table 2 - ID (foreign key - relationship between ID in Table 1 is set up), Personnel Name, Phone, Fax Etc. Each Site can have several entries in Table 2...

How do you link the subreport to the parent report? I am very new to Access. Trying to teach myself! Thanks!!

I am using a subreport. This database is being used to keep all information on sites used for certain projects. See example below: Report 1 - has info such as name, main contact, mailing address etc. Report 2 - has personnel at each site Report 3 - combination of report 1 and 2 Report 1 -...

I need to combine 2 reports into one Master Report. Instead of making one huge table with all the information, the data was split into 2 tables. They now want a report that prints all the information out on one page. Here is my issue: Report 1 (master data) - asks for a parameter Report 2...

I understand I don't need to but is there a way to do it?

I have a Master Data Table and a Payments Table. I have a query that uses the relationship between the two to get the Total Payment (each specific entry in the Master Table will potentially have several payments so I made this query so we could keep track of what was paid so we can compare it...